Msgbox Automatic OK In VBA

[Schwimms]

Hi All,

I have a macro in my main workbook that runs before I get to work in the AM that opens several workbooks and runs macros within those workbooks. The macros within the other workbooks call msgbox's on open that ask the user if they want to refresh click ok or cancel. I am having issues where my main workbook opens the other workbooks but gets stuck on the msgbox's, so when I get in the workbook is just stuck on the msgbox. The reason I need these msgbox's is for users who are not able to refresh because of permissions.

Make sense? Any help please..

 

[Smitty]

You can use Application.EnableEvents = False to prevent the code in the other workbooks from firing. Just make sure to set it back to true at the end.

 

[Schwimms]

I was able to work with that. Thank you!