#1   Report Post  
Laurent M
 
Posts: n/a
Default deleting worksheet

Hello,

i would like to know how i can delete a worksheet
automaticaly without confirming it in the dialog box.

Thanks.
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

You need VBA, and to set displayalerts off

Application.DisplayAlerts = False
Worksheets("Sheet1").Delete
APplication.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Laurent M" wrote in message
...
Hello,

i would like to know how i can delete a worksheet
automaticaly without confirming it in the dialog box.

Thanks.



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
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM
Executing macro for all worksheet from a different worksheet Biti New Users to Excel 3 December 8th 04 10:05 AM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 06:10 PM


All times are GMT +1. The time now is 08:18 AM.

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

About Us

"It's about Microsoft Excel"