Q:
Deleting Excel Worksheets with macro
Microsoft Excel, Excel macros, Excel 2000, Excel workbooks, Excel worksheets, Microsoft Excel 2000, Excel 2000 macros, 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?
ASKED:
Nov 21 2008 0:38 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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
