Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros through VBA
HI,
I am trying to save as an excel workbook with macros but when the user will open it after the save as i dont want the macros to work. I have a form that kicks in in the Workbook_Open event, i dont want this event to occur after the save as. I know about Application.EnableEvents=False but if i use it it will disable the macros all the time, i need to disable it only when the user opens the copy after the save as. I googled for it but couldnt find anything. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros through VBA
Why not just set a flag in the code after the save that gets tested in the
macros, and the exit immediately if set. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... HI, I am trying to save as an excel workbook with macros but when the user will open it after the save as i dont want the macros to work. I have a form that kicks in in the Workbook_Open event, i dont want this event to occur after the save as. I know about Application.EnableEvents=False but if i use it it will disable the macros all the time, i need to disable it only when the user opens the copy after the save as. I googled for it but couldnt find anything. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros through VBA
Bob,
Do you mean like testing the content of a cell or something? Thanks, On Jan 28, 7:27 pm, "Bob Phillips" wrote: Why not just set a flag in the code after the save that gets tested in the macros, and the exit immediately if set. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in oglegroups.com... HI, I am trying to save as an excel workbook with macros but when the user will open it after the save as i dont want the macros to work. I have a form that kicks in in the Workbook_Open event, i dont want this event to occur after the save as. I know about Application.EnableEvents=False but if i use it it will disable the macros all the time, i need to disable it only when the user opens the copy after the save as. I googled for it but couldnt find anything. Thanks,- Hide quoted text -- Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros through VBA
No, what I was referring to was a public global variable. I was suggesting a
variable as it would automatically re-initialise on next opening. The problem with using a cell is that you would need to clear it before closing the workbook. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... Bob, Do you mean like testing the content of a cell or something? Thanks, On Jan 28, 7:27 pm, "Bob Phillips" wrote: Why not just set a flag in the code after the save that gets tested in the macros, and the exit immediately if set. -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in oglegroups.com... HI, I am trying to save as an excel workbook with macros but when the user will open it after the save as i dont want the macros to work. I have a form that kicks in in the Workbook_Open event, i dont want this event to occur after the save as. I know about Application.EnableEvents=False but if i use it it will disable the macros all the time, i need to disable it only when the user opens the copy after the save as. I googled for it but couldnt find anything. Thanks,- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i disable macros? | Excel Discussion (Misc queries) | |||
disable macros? | Excel Programming | |||
Disable macros | Excel Programming | |||
How to disable macros? | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |