Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to force delete tabs
Hi,
i realize this is a lame VB question, but I can't find the way to force the sheets.delete function to skip the "are you sure" dialog box. Basically, I want a function at the start of my pivot table macro to do a "if exist, then delete; else create" Any code snippets out there that do this? thanks, Randy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to force delete tabs
Application.DisplayAlerts = False
Activesheet.Delete ' or sheets.Delete Application.DisplayAlerts = True -- Regards, Tom Ogilvy "Randy" wrote in message ... Hi, i realize this is a lame VB question, but I can't find the way to force the sheets.delete function to skip the "are you sure" dialog box. Basically, I want a function at the start of my pivot table macro to do a "if exist, then delete; else create" Any code snippets out there that do this? thanks, Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force Macro | Excel Discussion (Misc queries) | |||
Auto force a macro | Excel Discussion (Misc queries) | |||
force macro | Excel Programming | |||
Force Macro Enable | Excel Programming | |||
Force Delete a Sheet | Excel Programming |