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
 
You must log in or register to reply here.

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

HOW DO I INSERT 1 SPACE BEFORE A TELEPHONE NUMBER IN EXCEL SPREAD 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel 2007: Help creating a macro that will run Solver? 3
Reuse Application.WorksheetFunction 4
Compiler Error - Not an Appropriate Name 1
Disable Macro Alert 2
Excel Macro Warning problems 1
Macro security in 2007 5

Back
Top