Hi
Look at this thread:
http://groups.google.dk/group/micros...e093714?hl=da#
Regards,
Per
"PeterM" <(E-Mail Removed)> skrev i meddelelsen
news:544B1979-0607-4A32-ABC4-(E-Mail Removed)...
>I have a hyperlink in WorkbookA that opens up another spreadsheet,
>WorkbookB.
> When opened, WorkbookB always asks if I want to update WorkbookB with
> other
> data sources. The answer is always NO. How do I disable these system
> alerts
> on a file open when opening from a hyperlink. If I need to change the
> hyperlink to a pushbotton, that is no problem, but I still need to know
> how
> to disable the system alerts..
>
> Placing Application.DisableAlrets=True in the Open section of WorkbookB
> doesn't work.
>
> Any suggestions would be useful....thanks in advance for your help!