Prev: xlt start book
Next: Function to determine if a cell contains a formula
From: KrispyData on 25 Mar 2010 13:10
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!

From: Chip Pearson on 25 Mar 2010 13:52

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
<KrispyData(a)discussions.microsoft.com> 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!
 | 
Pages: 1
Prev: xlt start book
Next: Function to determine if a cell contains a formula