Deleting Excel Worksheets with macro
Excel 2000, Excel 2000 macros, Excel macros, Excel workbooks, Excel worksheets, Microsoft Excel, Microsoft Excel 2000, Microsoft Excel 2000 macros
I am using excel 2000 and have workbook that uses macro to delete several worksheets and then save the workbook under a name in one of the cells. All works fine but for each worksheet a quiery pops up to ask if you want to delet this sheet. How do I delete sheets in the macro without having this pop up window?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 21, 2008 12:38 AM
UPDATED:
December 31, 2008 7:09 AM
Answer Wiki:
Look under macro ... there will be MsgBox command. (this is the message that pops up)
Try commenting out the MsgBox command.
You then also need to adjust accordingly the corresponding Event/Cancel response to the pop up.
I have Excel 2007 (but Excel 2000 should work similarly)
Hi
How about adding ...
Application.DisplayAlerts = False
Your code
Application.DisplayAlerts = True
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
