Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off System Messages
I have a line of code (excel 2000) that deletes a sheet. When it runs a
system message pops up and asks if I really want to delete the sheet. Is there any way that I can turn this system message off? Thanks! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off System Messages
Bruce,
Just prior to that line of code to delete the sheet: Application.DisplayAlerts = False and right after it Application.DisplayAlerts = True John Bruce B wrote: I have a line of code (excel 2000) that deletes a sheet. When it runs a system message pops up and asks if I really want to delete the sheet. Is there any way that I can turn this system message off? Thanks! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off System Messages
Thanks John! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert military date system to standard date system | Excel Discussion (Misc queries) | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
System Messages | Excel Discussion (Misc queries) | |||
Msg.box -messages | Excel Discussion (Misc queries) | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) |