PC Review


Reply
Thread Tools Rate Thread

How do I make excel not prompt before deleting worksheets?

 
 
=?Utf-8?B?TGFyIENoZW4=?=
Guest
Posts: n/a
 
      12th Jul 2006
I am trying to delete worksheets in an excel workbook without it prompting me
if i'm sure everytime i do this. Any ideas?
 
Reply With Quote
 
 
 
 
Nick Hodge
Guest
Posts: n/a
 
      12th Jul 2006
If you are talking about manually, there is no way around it and believe me,
one day you will be happy it does.

If this is part of a macro, use

Application.DisplayAlerts = False

before you delete the sheet and the =True after

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Lar Chen" <Lar (E-Mail Removed)> wrote in message
news:B7988C3B-1CA3-4CFC-8102-(E-Mail Removed)...
>I am trying to delete worksheets in an excel workbook without it prompting
>me
> if i'm sure everytime i do this. Any ideas?



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      12th Jul 2006
Lar Chen

Sub SheetDelete()
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End Sub

Only way to get the sheet back is to close without saving, so be careful.


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 14:00:02 -0700, Lar Chen <Lar
(E-Mail Removed)> wrote:

>I am trying to delete worksheets in an excel workbook without it prompting me
>if i'm sure everytime i do this. Any ideas?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleting excel worksheets neerak via AccessMonster.com Microsoft Access VBA Modules 3 29th Feb 2008 01:57 AM
Deleting or moving flagged email...Can I make outlook prompt me? =?Utf-8?B?U3Bpa2VNYW4=?= Microsoft Outlook Discussion 0 4th Oct 2006 01:15 AM
How to make Save prompt come up on Excel workbook =?Utf-8?B?U2FtbWk=?= Microsoft Excel Misc 6 4th Aug 2006 11:10 PM
Prompt before deleting worksheets? =?Utf-8?B?Y2Jyb29rczQyMQ==?= Microsoft Excel Misc 2 20th Jul 2005 05:32 AM
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000 L Mehl Microsoft Excel Misc 2 27th Jul 2004 07:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:46 AM.