View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default VBAProject Scope

Hi
you have to store these macros in your personal.xls file. See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Bill Baker wrote:
Something seems to have changed in Excel 2003 as far as macro's are
concerned. In Excel 2000, I could create a macro and have it
available in all files. Now each macro is tied to each excel file,
and I have to open the file that the macro was created in in order to
access it.

Is there a way to make my macro's "global" in Excel 2003?

Thanks,