Re: Enable automatic refresh prompt

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: suppress output
    ... how can one suppress the output of the tcl prompt? ... searching the docs did not help me much. ... The prompt only shows up ...
    (comp.lang.tcl)
  • Re: Suppress Prompt
    ... Lynn wrote: ... active file. ... I would like to suppress the prompt that appears when ...
    (microsoft.public.word.vba.general)
  • Re: Updating Links
    ... In versions of Excel prior to xl2002, you either update automatic links ... without prompt, or you get prompted. ... > message re updating links. ...
    (microsoft.public.excel.programming)
  • Re: Enable automatic refresh prompt
    ... This data refresh it is prompting for is for ... > either have the links update with no prompt or be prompted. ... > code from another workbook, I don't believe displayalerts will suppress ... > in the workbook.Open command to suppress it. ...
    (microsoft.public.excel.programming)
  • Re: suppress output
    ... how can one suppress the output of the tcl prompt? ... The prompt only shows up interactively, and running interactively without a prompt seems highly unusual. ... Can you describe your problem in any more detail than "how can one suppress the output of the tcl prompt"? ... vast majority of scripts this isn't necessary. ...
    (comp.lang.tcl)