View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.