Macro's available all the time

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I have some macro's I would like to store in the default template of
Excel, can any one tell me how to do this?

Pete
 
Determine if you already have the file you need to add your macros to, that
is "personal.xls";

Start, Find enter: personal.xls << more thant likely in your XLStart
Folder.
if not creat a new workbook <<leave it blank>>and name it personal.xls and
save it there in XLStart folder that should already exist under your excel
programs, whereever they rest on your hard-drive.

If the file already exists then open it and proceed:

While in your new personal.xls file Do an Alt-F11 the VBE app comes up -
with the personal project selected in the explorer portion of the left
window - do a menu Insert, module;
In the code window that is created paste in your macros;
Close the VBE app.
Back in excel Click on the menu - select Window, select Hide, then save and
close.
 
Do you really mean the default workbook template or the
Personal macro workbook?

I'm not sure why you would want your macros added to every
new workbookyou create.

If you want to have your macros available all the time,
you need to store them in Personal.xls

Here's how:
1) Go to the VBE (ALT+F11)
2) Open Project Explorer (CTRL+R)
3) Find the Personal.xls project
4) If you find the Personal.xls project, copy you macros
in there.
5) If there is no Personal.xls project go back to Excel
and record a dummy macro, such as changing the font on a
cell. On the 'Record Macro' dialog box select 'Personal
Macro Workbook' from the 'Store macro in' option.
6) Go back to the VBE, find the Personal.xls project and
copy your macros into Module1 (Delete the dummy macro).
7) From within the VBE, save changes to Personal.xls
8) Now your macros will always be available.


Francis Hayes (The Excel Addict)

TheExcelAddict.com

Helping Average Spreadsheet Users
Become Local Spreadsheet Experts

Get a free weekly tips newsletter at
http:/www.TheExcelAddict.com
 
Back
Top