Hey all,
I am opening a workbook that always asks if I want to Update when it is open. I don't want that message to so up and click don't update.
I have added the Application.screenUpdate = false and Applicaiton.DisplayAlerts = false in my code, but I guess those are not the right ones.
What should I be using?
Thank you for your help,
Matt
Do you have them in the: "ThisWorkbook" Workbook_Open event?
Click on the * icon if this post has been helpful.
No I don't. The macro I am running is in one workbook and in the macro I am opening another workbook and it is that workbook that I get the update message so my user has to click update or don't update before continueing with macro
In the second workbook, in the: "ThisWorkbook" Workbook_Open event you need to put the Applicaiton.DisplayAlerts = false
Please Login or Register to view this content.
in the line where you open the workbook specify the updatelinks:=false argument
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks