Where to store standard macros

  • Thread starter Thread starter GB
  • Start date Start date
G

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
 
Geoff,

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

HTH,
Bernie
 
Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.
 
Tom Ogilvy said:
Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.
Click to expand...

I have thought about it, and I cannot see why that is a disadvantage. Could
you kindly enlighten me, please.
 
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.
 
Back
Top