will a macro transfer to another computer if I e-mail the file?

D

Duplatt

I have an 11 page spreadsheet to distribute to others in our condo association
The workbook has a macro to convert printing from letter to legal and back.
The macro does not transfer to the other computers.
Is there a way to make this happen?
Thank You
Duane Platt
 
J

Jim Thomlinson

My best guess is that the security on the other computers is set to high.
Have them set it to medium and when prompted they should select enable
macros...

Tools|Macros|Security -> Medium
 
D

Duplatt

Jim - I did some further research based on your Security suggestion.
It seems that I need a Certified Digital Certificate to transfer macros from
one computer to another. I can certify myself to deactivate the "allow macro"
flag but, it only works on the host computer. It was worth the try. Thanks
again
Duane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer e-mail contacts 0
Transfer mail from one computer to another 1
Need to transfer e-mail contacts 1
Transfer Outlook e-mail structure To Another Computer 4
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Transfer Macro code to another computer 0
sending a macro to another person 1
Locking the macro view function 5

Top