On Dec 19, 10:51 pm, Rick wrote:
Where does one store a called macro that would be used by many excel
programs? And how is this procedure done, as well as how is the macro coded
Public or Private?

Place the macro in i.e. personal.xla placed in the folder XLStart. Any
files in XLstart will be loaded when Excel is started.

If the macro is Private it won't be visible in the Run macro dialog
(Alt-F8), if you _allways_ calls the macro from menus or other macros
you could set it Private. But if you need to activate the Macro from
Run macro dialog, it should be Public.

/Tommy, DK