Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro, Auto Return
I'm writing a macro in excel and have to create temporary tabs within the
file, and then delete them. Is there any way I can write into the macro a key return so when it asks if I'm sure I want to delete it does it automatically, because everytime I run the macro it stops at the point the temporary sheet is being deleted and wants me to confirm it, and I have to hit enter to continue |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro, Auto Return
hi
just before the delete, add this line Application.DisplayAlerts = False then after the delete has happened, add this line Application.DisplayAlerts = true regards FSt1 "Baloney12" wrote: I'm writing a macro in excel and have to create temporary tabs within the file, and then delete them. Is there any way I can write into the macro a key return so when it asks if I'm sure I want to delete it does it automatically, because everytime I run the macro it stops at the point the temporary sheet is being deleted and wants me to confirm it, and I have to hit enter to continue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto return to sheet 1 | Excel Programming | |||
Auto return | Excel Worksheet Functions | |||
how can you auto return from columns B1 to A2 | Excel Discussion (Misc queries) | |||
"Auto-return" | Excel Discussion (Misc queries) | |||
Auto Return | Excel Discussion (Misc queries) |