• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Make macro work after email

kevinonearth

kevinonearth

Member
Hi,
If I send a workbook containing a macro, it will not work on the recipients machine. How do I set up my workbook so that when I send it the macros will work on the recipient's computer?
 
First, make sure the file extension is either .xls, .xlsm, or .xlsb
If it's .xlsx, the macro will get stripped. Next, the recipient may need to enable macros. This usually appears as a toolbar just under the ribbon.
 
Thanks for the reply but I've saved it as a Macro enabled workbook and I've enabled all macros on the recipient's computer, but they still get the same error message!
 
Do I have to save my macros in personal folder or do I place the macro in the worksheet? I'm not quite sure how to manage my macros, how or where I should save them
 
Does the workbook [the one saved as xlsm] that you send to others, contain all the needed macros or are there some other macros outside this workbook?

Can you post the error message please? It is possible that the error, after all, may not be due to macro's absence.
 
As Shrivallabha indicated, the macros need to be saved with the file you are transferring. Please share what the actual error message says.
 
You must log in or register to reply here.
Back
Top