Macros applied to all workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anybody know how to set up macros that apply to all workbooks open in the future? I believe it has something to do with saving the macro on a worksheet that automatically opens up when you open Excel, however I am not sure. Any help would be greatly appreciated.\
Nick
 
Hi Nick!

Save or record the macro in your Personal.xls file.

To see if you already have one, use

Windows > Unhide > Take a look > Cancel
If you see it there, you have it already

If you haven't got one, use:

Tools > Macro > Record new macro
Select place for it to be recorded as Personal macro workbook
OK
Make a few format changes
Stop the recording.

You now have a Personal.xls file which you can record new macros in
and to which you can copy your existing ones.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Nick Mouz said:
Does anybody know how to set up macros that apply to all workbooks
Click to expand...
open in the future? I believe it has something to do with saving the
macro on a worksheet that automatically opens up when you open Excel,
however I am not sure. Any help would be greatly appreciated.\
 
Nick

You should save them in your Personal Macro Workbook which contains macros
available to all workbooks.

If you don't have a Personal Macro Workbook...........

On menu go to Tools>Macro>Record New Macro.

You will be presented with a dialog box with Macro1 as name of macro. Below
that is "Store macro in". Select Personal Macro Workbook.

Record something simple like copying a cell and pasting. Stop Recording.
Close Excel and you will be asked if you want to save changes to Personal.xls

Click Yes. You now have a Personal.xls which will open each time you start
Excel. When it is open, you can go to Windows>Hide and make it hidden. Save
changes again.

The macros you create or copy to modules in the Personal.xls will be available
for all workbooks.

Gord Dibben Excel MVP
 
Norman & Gordon, I appreciate your help. I created a new personal.xls workbook, and now my macros apply to all new workbooks. Thanks again.

Nick Mouzourakis
 
Back
Top