Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro closing worksheet
I have a macro which opens and closes a worksheet.
Problem: when the worksheet is closed by the macro, it prompts me "Do you want to save". Is there anyway to get rid of this? There are a lot of opening and closing worksheets, so this is kind of annoying. Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro closing worksheet
Application.DisplayAlerts = False
and reset after. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jeff" wrote in message ... I have a macro which opens and closes a worksheet. Problem: when the worksheet is closed by the macro, it prompts me "Do you want to save". Is there anyway to get rid of this? There are a lot of opening and closing worksheets, so this is kind of annoying. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a macro select all cells in a worksheet? | Excel Discussion (Misc queries) | |||
worksheet function vs macro | Excel Discussion (Misc queries) | |||
2 windows for workbook - Macro switches worksheet | Excel Discussion (Misc queries) | |||
Macro wiping out worksheet | Excel Worksheet Functions | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel |