saving macro from workbook to Personal Macro Workbook

  • Thread starter Thread starter KrispyData
  • Start date Start date
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!
 
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
 
Back
Top