View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Crash[_2_] Crash[_2_] is offline
external usenet poster
 
Posts: 2
Default Universaly available macros

Record a macro, it will ask you where you want to save it, select
Personal Macro Workbook. This will create the Personal.xls for you.

Jon

Andrew J wrote:

In Excel 2002, how do you make a macro available to all
spreadsheets (not just new ones) that are opened? I have
added a button to the toolbar that runs the macro, but it
only runs on the workbook that it resides in. In older
versions you added it to personal.xls, but I'm not sure
how to do it in 2002. I don't have book.xlt on my machine
either, so can't use that.

Thanks in advance