Solved: Disabling Messages In Excel During Macro Runtime

[duluter]

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.


[vba]Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False[/vba]

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]

I searched the forum using google at the top of the page:
http://www.vbaexpress.com/forum/showthread.php?t=6413

[duluter]

D'oh! Feeling stupid.

Thanks very much.


Duluter

[lucas]

Duluter, if that solves your problem please mark your thread solved using the thread tools at the top of the page...