| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to suppress Excel default message
Hello -
I have a button that deletes a sheet. Prior to the sheet being deleted, Excel has a message box that pops up asking if you really want to delete it. I need to suppress that message. Is there a way you can keep default messages from displaying? Any help will be greatly appreciated! -- Sandy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to suppress Excel default message
Sandy,
Try code like Application.DisplayAlerts = False ' delete the sheet Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sandy" wrote in message ... Hello - I have a button that deletes a sheet. Prior to the sheet being deleted, Excel has a message box that pops up asking if you really want to delete it. I need to suppress that message. Is there a way you can keep default messages from displaying? Any help will be greatly appreciated! -- Sandy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to suppress Excel default message
Thanks, Chip!
-- Sandy "Chip Pearson" wrote: Sandy, Try code like Application.DisplayAlerts = False ' delete the sheet Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sandy" wrote in message ... Hello - I have a button that deletes a sheet. Prior to the sheet being deleted, Excel has a message box that pops up asking if you really want to delete it. I need to suppress that message. Is there a way you can keep default messages from displaying? Any help will be greatly appreciated! -- Sandy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suppress Update Links Message | Excel Discussion (Misc queries) | |||
| suppress Excel save message | Excel Programming | |||
| Suppress add-in confirmation message | Excel Programming | |||
| Automating Excel WorkBook With C# Suppress Excel Message Boxes Possible? | Excel Programming | |||
| suppress popup message | Excel Programming | |||
Hybrid Mode
