Sheet deletion
 

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

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

This is a change to excel.

If you never "used" that worksheet, excel won't bother with the prompt.

You could put something in any old cell and then hit delete (to clear the
cell). You'll be prompted again.



mitch wrote:

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

--

Dave Peterson

If you never "used" that worksheet, excel won't bother with the
prompt.

Are you sure about that? I just opened a brand new workbook,
tried to delete Sheet3, and got the prompt. This was in Excel
2003.


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




"Dave Peterson" wrote in message
...
This is a change to excel.

If you never "used" that worksheet, excel won't bother with the
prompt.

You could put something in any old cell and then hit delete (to
clear the
cell). You'll be prompted again.



mitch wrote:

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

--

Dave Peterson

Yep. Well, after I tested once more <bg.

I opened excel in safe mode and then added some worksheets and deleted an unused
sheet. No prompt.

Any chance you have something in sheet.xlt that's causing the prompt?



Chip Pearson wrote:

If you never "used" that worksheet, excel won't bother with the
prompt.

Are you sure about that? I just opened a brand new workbook,
tried to delete Sheet3, and got the prompt. This was in Excel
2003.

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

"Dave Peterson" wrote in message
...
This is a change to excel.

If you never "used" that worksheet, excel won't bother with the
prompt.

You could put something in any old cell and then hit delete (to
clear the
cell). You'll be prompted again.



mitch wrote:

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

--

Dave Peterson

--

Dave Peterson