similar to normal.dot

[bp]

hello,
i am looking to have some generic macros in excel. in word i can stick them
in normal.dot.
where can i put them in excel? in an *.xlt?

thanks

 

[Chip Pearson]

You can put them in your personal.xls file, typically located in
"C:\Program Files\Microsoft Office\Office\XLStart"

This will is opened when you start Excel. Personals.xls is
typically not visible.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peo Sjoblom]

Start by recording a macro, select personal macro workbook when prompted
where to put it, start and stop the recording, press alt + f11, double click
module1 in the left project pane of personal.xls, delete the text in there
and paste in your macros, when closing excel save the personal.xls when
prompted.
To run them press alt + f8


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[bp]

thanks all.
my folder C:\Program Files\Microsoft Office\OFFICE11\XLSTART is empty.
i created a personal.xls in that folder. put my macro in it.
however when i do a start>>........>>MS Excel the first document that comes
up is personal.xls.
if i click the new documet button, there is no macro in it.

any suggestions?

 

[Peo Sjoblom]

Did you create it by recording a macro?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[bp]

i just went into the vba, created new macro. then created the sub