to reuse macros

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

I written a macros in an excel . How I can reuse thsese macros in another
excel without copoying the above macros or without opening the previous excel
which contains macros
 
Store macros that you want to use in other workbooks in the PERSONAL.XLS
worksbook. This workbook opens in the background each time you open Excel
and is hidden from view, but you have access to all macros in the PERSONAL
workbook file.
 
Thanks for the reply

In which folder I can see that personal.xls. I am using 2007 excel. I
searched entire folder also hidden but I cant see that file anywhere
 
In which folder I can see that personal.xls. I am using 2007 excel. I
searched entire folder also hidden but I cant see that file anywhere
 
If you haven't recorded a macro into Personal Macro Workbook you won't have
a Personal.xls created.

At least this holds for Excel 2003 and earlier.

Don't know about 2007


Gord Dibben MS Excel MVP
 
Back
Top