I use the following command in the Excel Macro to delete an Exce
worksheet called "Report":
Sheets("Report").Delete
However when I run the macro, the user will be prompted if th
worksheet "Report" should be deleted.
I do not want user to be asked. Instead I want the worksheet "Report
to be deleted automatically.
Can anyone please advise if there is a command to "force" delete th
worksheet without asking the confirmation from user?
Million Thank
--
Message posted from
http://www.ExcelForum.com