 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / February 2006VBA Bypass Delete Sheet Warning
Friends, I have written VBA code that loops through 150 workbooks and performs various tasks on each workbook. One task I need to perform is deleting one sheet in each workbook. Problem is, the Excel Delete Sheet Warning message box appears before each deletion, which means I need to manually confirm the deletion 150 times. Is there a VBA way to turn off Excel's delete sheet warning (like there is in Access)? Thanks for your help ... bill morgan something like this Sub delsheet() Application.DisplayAlerts = False Worksheets("sheet3").Delete Application.DisplayAlerts = True End Sub  SignatureGary > Friends, > [quoted text clipped - 10 lines] > > bill morgan So simple! Thanks, Gary ... > something like this > [quoted text clipped - 19 lines] > > > > bill morgan application.displayalerts = false sheets("Whatever").Delete application.displayalerts = true SignatureHTH... Jim Thomlinson > Friends, > [quoted text clipped - 10 lines] > > bill morgan Excellent. Thank you, Jim ... > application.displayalerts = false > sheets("Whatever").Delete [quoted text clipped - 14 lines] > > > > bill morgan Hi Bill You can use this Application.DisplayAlerts = False 'Code Application.DisplayAlerts = True SignatureRegards Ron de Bruin http://www.rondebruin.nl > Friends, > [quoted text clipped - 10 lines] > > bill morgan Thanks, Ron. Everybody giving me the same answer, so must be the BEST way ... > Hi Bill > [quoted text clipped - 18 lines] > > > > bill morgan Sub .. Application.DisplayAlerts = False 'your code here ... Application.DisplayAlerts = True End Su Thanks, Dave. Glad I asked ... so simple, but would have taken me awhile to figure out. > Sub .. > Application.DisplayAlerts = False > 'your code here ... > Application.DisplayAlerts = True > End Sub |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.