Thread: saving macro from workbook to Personal Macro Workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default saving macro from workbook to Personal Macro Workbook

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



On Thu, 25 Mar 2010 10:10:01 -0700, KrispyData
wrote:

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!
Reply With QuoteReply With Quote