saving macro from workbook to Personal Macro Workbook

K

KrispyData

I have a macro saved to a workbook, let's call it Data.xls. I would like
this macro saved to my personal macro workbook so it can be available anytime
without having to open Data.xls so I can use this macro. How can I do this?
I am new to working with macros. Any help will be appreciated!
 
C

Chip Pearson

With both the workbook containing the macro now and the personal.xls
workbook open, go to the VBA editor (ALT F11) and there, expand the
tree nodes in the Project window on the left side of the screen (CTRL
R if it is not visible). Now, you can either drag the module from the
existing workbook to the personal.xls workbook, or, if you don't want
the entire module, create a new module in personal.xls and copy/paste
the code from the other workbook. Save both workbooks.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Personal Macro Workbook 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Personal Macro Workbook 1
Macro Will Not Save 2
Disable Macro Alert 2
Cannot find Personal Macro Workbook 2
Excel Macro-enabled Workbook 2
Personal Macro 1

Top