| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress worksheet delete verification msgbox
Thanks, Trevor.
"Trevor Shuttleworth" wrote: Application.DisplayAlerts = False ; your code ; Application.DisplayAlerts = True Regards Trevor "CurtB" wrote in message ... I have a workbook that creates new worksheets using a template worksheet and a data worksheet (kind of like a Word mailmerge). An index worksheet is also updated with the names of the created worksheets and hyperlinks to them. When I want to clear the workbook, I loop through the index worksheet calling the following macro that deletes the created worksheets. I also delete entries in the index. Sub Remove_Worksheet(WorksheetName As String) Sheets(WorksheetName).Select ActiveWindow.SelectedSheets.Delete End Sub This macro works fine, but a verification message is displayed each time a worksheet is to be deleted. Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete. Delete Cancel I was wondering if there is a command that will prevent this message box from being displayed and allow the worksheet to be deleted without requiring an individual user provided response for each one? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date verification | Excel Discussion (Misc queries) | |||
| how do I suppress printing blank lines in a worksheet? | Excel Discussion (Misc queries) | |||
| data verification question | Excel Worksheet Functions | |||
| data verification | Excel Discussion (Misc queries) | |||
| If a worksheet name is = to test then a msgbox appears | Excel Discussion (Misc queries) | |||
Threaded Mode
