Where to store standard macros

[GB]

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

 

[Bernie Deitrick]

Geoff,

For one, every time you make a new workbook, your macros will be in
it.

HTH,
Bernie

 

[Tom Ogilvy]

Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.

 

[GB]

Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.

I have thought about it, and I cannot see why that is a disadvantage. Could
you kindly enlighten me, please.

 

[Tom Ogilvy]

You find one macro isn't working as expected or you want to make it more
powerful.

You now get to change it in every workbook where you want the change.

A suggestion:

Make your macro workbook an addin and load the addin through tools =>
addins. This will avoid the problem with personal.xls and multiple
instances.