Thread: Sheet deletion
View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

Mitch,

Somehow, the DisplayAlerts property got set to False. Open the
VBA Editor (ALT+F11), then open the Immediate Window (CTRL+G),
and enter the following:

Application.DisplayAlerts = True

and press Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"mitch" wrote in message
...
Hi,
I am using excel 2003. When I delete a workbook sheet, it
doesn't prompt me
to delete, it automatically does it. How can I have excel
prompt me for
workbook sheet deletion? Thanks.

Mitch