| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Dialog Box
Thanks for the quick response!
Cheers -----Original Message----- Application.DisplayAlerts = False activesheet.Delete Application.DisplayAlerts = True -- Regards, Tom Ogilvy wrote in message ... Hi, I have a macro that involves deleting a sheet. However a dialog box asking whether the user should proceed with deletion appears, which is very annoying for users. Is there a way to stop this from appearing, either programmatically or by altering settings. I am using Excel 2002 and VBA. Thanks in Advance . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing text between hyphens and removing the hyphens | Excel Discussion (Misc queries) | |||
| Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
| Removing an addin from the addin's list dialog | Excel Programming | |||
Hybrid Mode
