• 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.

Recorded Macro

L

leimst

Member
Good Afternoon All,

I have recorded a macro which I attached to a forms button but when I emailed the spreadsheet to the end user, the macro was not functional because it is saved in my Personal Macro Workbook, Personal.xlsb. Is there a way to save it to just this particular workbook so that when I send the spreadsheet to someone else the macro is available for them to use?

Thank you in advance for any help,

Brian
 
Hi Brian ,

Just copy the code ( of the recorded macro ) into a new code module in the workbook which you want to email.

In fact , when you are recording a macro , Excel presents the save location option in the form of a drop-down labelled :

Store macro in

where the choices are :

Personal Macro Workbook
New Workbook
This Workbook

You can select from the above , before you start recording.

Narayan
 
You must log in or register to reply here.
Back
Top