Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make excel not prompt before deleting worksheets?
I am trying to delete worksheets in an excel workbook without it prompting me
if i'm sure everytime i do this. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make excel not prompt before deleting worksheets?
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 HIS "Lar Chen" <Lar wrote in message ... I am trying to delete worksheets in an excel workbook without it prompting me if i'm sure everytime i do this. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make excel not prompt before deleting worksheets?
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 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make editable PDF forms using Excel? | New Users to Excel | |||
Sorting Excel columns in several worksheets at once. | Excel Discussion (Misc queries) | |||
Excel 2007 MS Query prompt yields Syntax error | Excel Discussion (Misc queries) | |||
No prompt on exit in Excel 2003 | Setting up and Configuration of Excel | |||
Excel 2003 does not prompt to save changes when closing? | Excel Discussion (Misc queries) |