Macro Problems

[dlove]

I am trying to send an Excel document to other people that contains a button with an assigned macro. I haven't had any luck in getting the button to work once the document has been sent. What is the best way to get macros from one person to another without manually recording macros on each individual PC?

Any help is greatly appreciated.

Thanks,

 

[Smitty]

Welcome to the Board!

What happens in the version they receive?

You can always distribute your code as an Add-In, but that also requires making sure that it's essentially bulletproof before you do so.

 

[dlove]

Well, I checked to see if I stored it in "this workbook." I think I got the macro to perform at the recipients computer. The problem was I had to reset the security for macros on the other PC's in order for them to be able to run the macro.

I appreciate the speedy replies! I'm sure I will be utilizing this site more in the future given the amount of work I do with Excel.

 

[Smitty]

The problem was I had to reset the security for macros on the other PC's in order for them to be able to run the macro.

Take a look in the Excel helpfile for Self-Cert (Create your own digital certificate for self-signing). If you use that method your end-users will only need to accept your digital signature once.