Disable Worksheet Delete Warning
Greetings:
When my VBA macro deletes one of the worksheets in my workbook (through the Sheet.Delete method), I get the following warning: "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete." I then have to click on the Delete button to proceed with the action. Is there any way to suppress this annoying warning so that the worksheet will automatically get deleted? Respectfully, Charles |
Disable Worksheet Delete Warning
precede it with
Application.DisplayAlerts = False and reset to True after. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Charles in Iraq" wrote in message ... Greetings: When my VBA macro deletes one of the worksheets in my workbook (through the Sheet.Delete method), I get the following warning: "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete." I then have to click on the Delete button to proceed with the action. Is there any way to suppress this annoying warning so that the worksheet will automatically get deleted? Respectfully, Charles |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com