Runtime msgbox answer on workbook open

cprince

Board Regular
Joined
Jul 4, 2006
Messages
67
Hi all,

I have a macro and I need it to open workbook A in location AA. and then save it in location BB. Ive got it running fine, But in workbook A there is a msgbox in the workbook open event. during run time this msgbox appears. I ve tried the application.displayalerts. but this doesnt seem to stop it. Anyone have any ideas?

Thanks
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,111,599
Messages
5,541,166
Members
410,543
Latest member
ExcelGlenn
Top