Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BOHICA needs more help
Okay, you Kings of Code, you Princes of Productivity....Gots me
anutter question: I have a macro that deletes sheets in a workbook, then re-creates them in a specified format. When the command to delete the cell is executed, it pops up with a prompt saying these selected sheet(s) will be permanently deleted. Is there something I can do in my code to supress this annoying and needless (to me anyhow) pop up? BOHICA: The other white meat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BOHICA needs more help
Wrap your deletion with
Application.DisplayAlerts = False ActiveSheet.Delete Application.DisplayAlerts = True In article , (BOHICA) wrote: Okay, you Kings of Code, you Princes of Productivity....Gots me anutter question: I have a macro that deletes sheets in a workbook, then re-creates them in a specified format. When the command to delete the cell is executed, it pops up with a prompt saying these selected sheet(s) will be permanently deleted. Is there something I can do in my code to supress this annoying and needless (to me anyhow) pop up? BOHICA: The other white meat |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
BOHICA needs more help
Works like a charm! Thank you!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BOHICA needs help! | Excel Programming |