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!

Hi

Look at this thread:

http://groups.google.dk/group/micros...e093714?hl=da#

Regards,
Per

"PeterM" skrev i meddelelsen
...
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!