Disable Macros through VBA

[yspin]

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,

 

[Bob Phillips]

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)

 

[yspin]

Bob,

Do you mean like testing the content of a cell or something?

Thanks,

 

[Bob Phillips]

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)