Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default avoid message that asks for confirm delete sheet

What statement can avoid the confirmation of deleting a worksheet during a
macro run?

thank you
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default avoid message that asks for confirm delete sheet

Craig,

Application.displayalerts=false

'your delete code

Application.displayalerts=true

Mike

"Craig" wrote:

What statement can avoid the confirmation of deleting a worksheet during a
macro run?

thank you

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
Avoid Window Message while deleting a sheet maperalia Excel Programming 4 June 19th 07 04:36 PM
how can i avoid an error message while printing an excel sheet solidad Excel Discussion (Misc queries) 1 August 13th 06 01:00 PM
Add message box to confirm run macro Anolan Excel Programming 4 January 14th 06 03:00 PM
Confirm Delete Message Disable RiosPapa New Users to Excel 2 October 7th 05 09:02 PM
Message box to confirm action CRayF Excel Programming 4 September 21st 05 01:03 AM


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