Need to disable my vba macro once I email out the file.
 

I have a macro that opens automatically, runs a couple of calculations and is
programmed to email the completed workbook at the end. I want a way to
disable the macro when i send it so when it is opened by the recipients, the
macro does not automatically start again.

Thanks,

Chris

Need to disable my vba macro once I email out the file.
 

On Apr 17, 2:14*pm, Chris wrote:
I have a macro that opens automatically, runs a couple of calculations and is
programmed to email the completed workbook at the end. *I want a way to
disable the macro when i send it so when it is opened by the recipients, the
macro does not automatically start again.

Thanks,

Chris

You can save a copy of the file you produce and delete the code inside
it ... or else modify the code so that it's in a workbook all by
itself and it works on a different file ...

As for disabling the macro ... you could check for the username
(something like this
http://groups.google.com/group/micro...c180f20f310923
) and only run the code if you're the logged-in user ... or you could
require a password to start the code ... etc

HTH

Chris

Need to disable my vba macro once I email out the file.
 

Do you know any code off hand that would allow me to save the file and delete
out the vba like you stated at the beginning of the reply?

Thanks...

"cht13er" wrote:

On Apr 17, 2:14 pm, Chris wrote:
I have a macro that opens automatically, runs a couple of calculations and is
programmed to email the completed workbook at the end. I want a way to
disable the macro when i send it so when it is opened by the recipients, the
macro does not automatically start again.

Thanks,

Chris

You can save a copy of the file you produce and delete the code inside
it ... or else modify the code so that it's in a workbook all by
itself and it works on a different file ...

As for disabling the macro ... you could check for the username
(something like this
http://groups.google.com/group/micro...c180f20f310923
) and only run the code if you're the logged-in user ... or you could
require a password to start the code ... etc

HTH

Chris

Need to disable my vba macro once I email out the file.
 

Look at Chip Pearson's site:

http://www.cpearson.com/excel/vbe.aspx

Cliff Edwards