Back to question Answer 1 of 1

Discuss SpreadsheetsDirect's answer to: Embedding Macro in and Excel Workbook

I am very new to creating excel Macros. I used a guide to create a Insert Date macro. I then inserted a small picture of a calendar and assigned my macro to it. The function works perfectly fine on ...

SpreadsheetsDirect Answered:

You can either put your macros in Personal.xls which loads up when Excel is started or in the actual book you're working with. To move it out of the Personal.xls open Excel and press Alt-F11 to bring up Visual Basic. On the left you should see the Project window with any open files in. Find Personal.xls and click the + to expand. Do the same for Modules and find your macro. Copy the code and find your new book in the Project window and, if needed right click on the filename and select Insert - Module then paste the code into the new module. You'll will then need to reassign the macro to make it point to the new location.