Disable System Alerts on File Open

P

PeterM

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Name of file opened, being viewed 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Formulas Won't Run if I Open File from Explorer 0
VBA Stmt Format to Get Contents of Cell in Another Book 1
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
BeforeClose Dilemma 0

Top