Re: Enable automatic refresh prompt

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am not familiar with that prompt - sorry.

--
Regards,
Tom Ogilvy


"Richard Edwards" <do.not.use@xxxxxxxxxxxxxx> wrote in message
news:%231Mg%23bnIGHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
> The Edit=>Links is greyed out. This data refresh it is prompting for is
for
> an ODBC link out to an Oracle Database...
>
>
> "Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
> news:OTw1CXnIGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
> > If you are talking about updating links, in xl2002 and earlier, you can
> > either have the links update with no prompt or be prompted. Code
doesn't
> > run before the question is asked and if you are opening the workbook
with
> > code from another workbook, I don't believe displayalerts will suppress
> > this - however in that situation, you can just use the UpdateLinks
> > argument
> > in the workbook.Open command to suppress it.
> >
> > In Excel 2003 there is an option under Edit=>Links to suppress it.
> >
> > (I could be misremembering, but I don't believe this option was added
> > until
> > 2003. If it was any earlier, it was xl2002, but I believe not).
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Richard Edwards" <do.not.use@xxxxxxxxxxxxxx> wrote in message
> > news:uROueRmIGHA.604@xxxxxxxxxxxxxxxxxxxxxxx
> >> I am trying to disable the automatic refresh prompt when loading a
> > workbook.
> >>
> >> I have tried the Application.DisplayAlerts = False but no joy.
> >>
> >> Anyone help?
> >>
> >> Thank you.
> >>
> >> Richard
> >>
> >>
> >
> >
>
>


.

Relevant Pages

  • Re: After Save Event - Confirm
    ... I think you need to program the before close (this fires before the before ... user will get the save prompt. ... >> Regards, ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Close file without saving
    ... Tom Ogilvy Wrote: ... > I have never seen a prompt from ... it just doesn't work anymore. ... Regards, ...
    (microsoft.public.excel.programming)
  • Re: Looking for Userform examples - site on web, download examples
    ... Regards, ... Tom Ogilvy ... > I'm in the process of building a few userforms that prompt for input and ...
    (microsoft.public.excel.programming)
  • FW: Boot device: disk:a file and args
    ... I'd like to thank Pere Blay to the solution below, my server managed goto OK ... >How can I continue to go to ok prompt? ... >Thanks & regards, ... >11900 Bayan Lepas, Penang, Malaysia ...
    (SunManagers)
  • Re: Customising system messages
    ... > So this expiring prompt is to advise users to go to that Domino web site ... > Best Regards, ... >> Microsoft MVP Windows Server - Active Directory ... >>> I need to customise the messages of this prompt to inform ...
    (microsoft.public.win2000.active_directory)