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