Thread: to reuse macros
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default to reuse macros

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


On Fri, 17 Oct 2008 09:33:07 -0700, pol
wrote:

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


"Jim Thomlinson" wrote:

You probably want an addin...

http://www.cpearson.com/excel/CreateAddIn.aspx
--
HTH...

Jim Thomlinson


"pol" wrote:

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