LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default Delete sheet automatic

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


Gord Dibben MS Excel MVP

On Fri, 11 Sep 2009 17:26:02 -0700, David
wrote:

Hi Group,

I am trying to allow a sheet deletion with out having to manually click the
Delete button which comes up in the process.

Thanks,
David


 
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
Automatic delete row in Excel 2003 Marc Robinson Excel Discussion (Misc queries) 1 April 18th 08 08:12 AM
How do I set up an automatic delete or move of a row of data? Zo Excel Discussion (Misc queries) 4 November 24th 05 08:35 PM
What is an automatic way to delete all rows of a certain kind Najeeb Excel Discussion (Misc queries) 1 May 19th 05 11:39 PM
automatic delete possible? musicgirl Excel Worksheet Functions 1 November 11th 04 05:06 AM
AUTOMATIC DELETE zebra Excel Programming 1 August 26th 04 01:55 PM


All times are GMT +1. The time now is 05:52 AM.

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

About Us

"It's about Microsoft Excel"