Why no "Organizer" as in Word
 

Is there a reason why Excel does not have the "Organizer" function that Word
has? Organizer allows you to transfer either macros or toolbars from one
machine to another very easily. It isn't quite that simple with Excel.

Thanks.

Why no "Organizer" as in Word
 

The reason is probably that XL and Word have very different
architectures. Word stores toolbars in a template (by default,
Normal.dot). That's usually not the case in XL, where toolbars are
stored and accessible system-wide in an .xlb file. The Organizer
wouldn't help with that. All you need to do to transfer a toolbar is to
attach it to a workbook (Tools/Customize) and open the workbook on the
other machine.

Macros can be exported and imported, but unlike Word, where macros are
usually stored in the attached template, XL's templates aren't attached
to generated documents - if the macro exists in the .xlt file, it will
exist in the .xls file, so no transfer is needed.


In article <9nb4f.24134$yS6.695@clgrps12,
"Darrell" wrote:

Is there a reason why Excel does not have the "Organizer" function that Word
has? Organizer allows you to transfer either macros or toolbars from one
machine to another very easily. It isn't quite that simple with Excel.