Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run when file is created from a template
Excel 2002: I want to display a series of dialog boxes
when a new file is created from a template, but not have the dialog boxes display for subsequent file opens. In Word you name the macro AutoNew to do this, but Excel only seems to have Auto_Open, which opens every time the file is reopened. I have a workaround that requires the user to click a button that bypasses the dialog boxes. Is there a way to get the file to "remember" that it has already run the macro and doesn't need to run it again? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run when file is created from a template
you could stash a value to indicate whether or not to run the macro on a
hidden sheet "Jim Birch" wrote in message ... Excel 2002: I want to display a series of dialog boxes when a new file is created from a template, but not have the dialog boxes display for subsequent file opens. In Word you name the macro AutoNew to do this, but Excel only seems to have Auto_Open, which opens every time the file is reopened. I have a workaround that requires the user to click a button that bypasses the dialog boxes. Is there a way to get the file to "remember" that it has already run the macro and doesn't need to run it again? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run when file is created from a template
Jim
AFAIK you have to put a value in the sheet. Then if A1 = Y exit sub end if You could hide the column as well Regards Peter -----Original Message----- Excel 2002: I want to display a series of dialog boxes when a new file is created from a template, but not have the dialog boxes display for subsequent file opens. In Word you name the macro AutoNew to do this, but Excel only seems to have Auto_Open, which opens every time the file is reopened. I have a workaround that requires the user to click a button that bypasses the dialog boxes. Is there a way to get the file to "remember" that it has already run the macro and doesn't need to run it again? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Document Not Saved" Saving File Created from Template PLEASEHELP!!!! | Excel Discussion (Misc queries) | |||
How do I distribute a template created with Template Wizard ? | Excel Discussion (Misc queries) | |||
Datestamping a file created by a macro | Excel Discussion (Misc queries) | |||
Macro Template File | Excel Worksheet Functions | |||
Moving Database file created by Template Wizard | Links and Linking in Excel |