option to not run macro on startup with timer

[one_inch]

Hello,

I have a macro that runs when a spreadsheet is opened however i sometimes need it not to run. Rather then furiously hit escape i was hoping to get a dialog box that would prompt yes/no to run the macro and if an option was not chosen after a few second then to run the macro anyway (so basically only by clicking "no" would you stop the macro from running).

I found this code here that gives me the yes/no message box and the 5 second time-out to get rid of the message box, however if the message times out it doesn't run the macro. Any ideas what i need to tweak to make it do so if no input comes from the user?
http://www.excelforum.com/excel-prog...s-reached.html


Thank you!

[HaHoBe]

Hi, one_inch,

adjust the code for the Workbook_Open event in ThisWorkbook accordingly:

Please Login or Register  to view this content.

Ciao,
Holger

[one_inch]

Hi Holger,

Thanks for your reply, it didn't quite work as excel wouldn't sat on the splash screen while it waited for the uer input, but wouldn't time out the message box as it had not finished loading the program (i think, it was just in limbo). I managed to put an application.ontime command into the workbook open code to get it to wait a few seconds while excel loaded properly and then called your code as a seperate macro and it worked a treat.

Thanks again