| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a sheet during macro
During a macro, a sheet is deleted. However, the user gets a box that
basically asks if it’s ok to continue. The message is “Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete.” Is there a way to prevent this message from coming up? It will only cause confusion to the user. Thanks, jeff |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting a sheet during macro
Try it this way...
Application.DisplayAlerts = False Sheets("Sheet8").Delete 'Change sheet name as needed Application.DisplayAlerts = True -- Rick (MVP - Excel) "jeff" wrote in message ... During a macro, a sheet is deleted. However, the user gets a box that basically asks if it’s ok to continue. The message is “Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete.” Is there a way to prevent this message from coming up? It will only cause confusion to the user. Thanks, jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a sheet with VBA | Excel Programming | |||
| Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming | |||
| Advanced Filter vs. Macro for deleting dup rows in sheet | Excel Programming | |||
| Deleting a sheet | Excel Programming | |||
| Deleting a Sheet | Excel Programming | |||
Hybrid Mode
