uktous
03-10-2012, 09:00 AM
Hi,
I use the following code to delete a sheet. However, a message box appears with the following message.
I don’t want the message box. How can I do?
Code:
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Delete
Message on message box:
Data may exist in the sheet(s) selected for deletion. To permanent delete the data, press Delete.
I use the following code to delete a sheet. However, a message box appears with the following message.
I don’t want the message box. How can I do?
Code:
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Delete
Message on message box:
Data may exist in the sheet(s) selected for deletion. To permanent delete the data, press Delete.