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 |
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 |
All times are GMT +1. The time now is 01:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com