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,

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,

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 -

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 -