#1   Report Post  
Old August 18th 05, 10:58 PM
mitch
 
Posts: n/a
Default 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

  #2   Report Post  
Old August 18th 05, 11:04 PM
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



  #3   Report Post  
Old August 18th 05, 11:32 PM
Dave Peterson
 
Posts: n/a
Default

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
  #4   Report Post  
Old August 18th 05, 11:45 PM
Chip Pearson
 
Posts: n/a
Default

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



  #5   Report Post  
Old August 19th 05, 12:10 AM
Dave Peterson
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
How do I determine automatically that a sheet is empty? [email protected] Excel Worksheet Functions 4 May 9th 05 08:15 PM
Entering Data in multiple cells on one sheet & having it auto upda haynblend Excel Worksheet Functions 2 March 27th 05 12:41 AM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM


All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017