Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Delete a Worksheet

Hi All
I have a macro that has to delete a worksheet but when it runs the pop box
asks if i am sure, can this be turned off in the macro so it deletes without
asking for verification???

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Delete a Worksheet

application.displayalerts = false


"Andym" wrote:

Hi All
I have a macro that has to delete a worksheet but when it runs the pop box
asks if i am sure, can this be turned off in the macro so it deletes without
asking for verification???

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
delete value on worksheet 2 that match values on worksheet 1 np Excel Discussion (Misc queries) 0 December 10th 09 06:02 PM
delete worksheet Peggy Sue Excel Worksheet Functions 3 November 6th 06 11:30 PM
How to delete a duplicate Excel worksheet within that worksheet? jozawun Excel Discussion (Misc queries) 6 September 19th 06 02:20 PM
Delete Worksheet with VBA Josef33 Excel Programming 0 September 3rd 04 10:01 AM
WorkSheet.Delete Pokey* Excel Programming 4 August 30th 04 06:54 PM


All times are GMT +1. The time now is 09:16 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"