LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 135
Default Can you bypass excel generated pop ups.

wandering, use this

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Wandering Mage" wrote in message
...
I am using a macro to delete sheets. I don't want excel
to ask if you are sure if you want to delete the sheets.
Is there anyway to make the prompt boxes stop popping up?



 
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
Bypass unlocked cell on protected worksheet in Excel 2003? berniean Excel Discussion (Misc queries) 8 July 28th 09 11:10 PM
Bypass Auto_open Macro in Excel 2007 BradJohnson Excel Discussion (Misc queries) 3 April 9th 09 05:28 PM
any way to bypass Excel Limit of 255 rows? griff Charts and Charting in Excel 0 November 9th 05 04:18 PM
excel.exe has generated errors Mrich Excel Discussion (Misc queries) 7 December 31st 04 09:28 PM
Excel.exe has generated errors Mrich New Users to Excel 6 December 31st 04 09:28 PM


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