View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GB[_3_] GB[_3_] is offline
external usenet poster
 
Posts: 70
Default Where to store standard macros

The standard approach to storing standard macros is to put them in the
Personal.xls spreadsheet.

I find that this causes a slight problem if I open two instances of Excel. I
get told that personal.xls is already in use, and asked whether I want to
make a read-only copy.

It occurs to me that I can get around this by putting my macros in Book.xlt.
On a quick trial, it seems to work.

So, before I go down that route, what are the problems with doing that?

Thanks

Geoff