View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Andrew J Andrew J is offline
external usenet poster
 
Posts: 4
Default Universaly available macros

Thanks Norman, but I don't have personal.xls. Unhide is
disabled also.


-----Original Message-----
Hi Andrew!

You still record it in your Personal.xls
You can see if it currently booted up using Window

Unhide

If you previously had one you can search for it using

Explorer

But in preference you might prefer converting your

favorites to an
Addin as that makes them easily portable to another

computer.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax

and Arguments)
available free to good homes.
"Andrew J" wrote in

message
...
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



.