PDA

View Full Version : Solved: Disabling Messages In Excel During Macro Runtime



duluter
02-05-2009, 09:22 AM
Hi.

I have a macro that opens up a bunch of workbooks one at a time, grabs data, and closes them. These workbooks have links to other workbooks and when I open them from my macro, Excel pops up a message asking me if I want to update the links. I don't want to update the links, and I don't want to see this message because it prevents the macro from running without user interaction.

I have the following code to attempt to prevent these messages from appearing. This code seems to work fine when I run the macro in Excel 2007. But the messages still pop up when I run the code on Excel 2003. My users are using 2003, so I need this to work in that environment.


Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False

Can anyone tell me why the above code is not preventing Excel from popping this message up? What is the code I should be using?


Thanks very much.

Duluter

lucas
02-05-2009, 09:39 AM
I searched the forum using google at the top of the page:
http://www.vbaexpress.com/forum/showthread.php?t=6413

duluter
02-05-2009, 09:43 AM
D'oh! Feeling stupid.

Thanks very much.


Duluter

lucas
02-05-2009, 09:45 AM
Duluter, if that solves your problem please mark your thread solved using the thread tools at the top of the page...