View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default independent macros

You will (probably) already have a WB called Personal.xls in your XLSTART
folder. All WBs in this folder are automatically opened when Excel starts.
So you can either save the macro to this WB or save your new WB to this
folder.
Either way, you macro will be available to all.

NickHK

wrote in message
ups.com...
Does this mean that, after writing the Macro in an open workbook, we
have to save it as: Personal.xls?