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

Where to store standard macros
 

Geoff,

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

HTH,
Bernie


"GB" wrote in message
...
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

Where to store standard macros
 

Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.

--
Regards,
Tom Ogilvy


"GB" wrote in message
...
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

Where to store standard macros
 

"Tom Ogilvy" wrote in message
...
Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.

--
Regards,
Tom Ogilvy


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

Where to store standard macros
 

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.



--
Regards,
Tom Ogilvy



GB wrote in message
...

"Tom Ogilvy" wrote in message
...
Your macros will be placed in every workbook you open.

Some would consider that a disadvantage.

--
Regards,
Tom Ogilvy


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