View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Excel 2003 macros

When you save the file as an add-in it will be saved in your default folder
which you have set up In ToolsOptionsGeneral.

You would copy it from there to a floppy or other removable media and carry it
over to her computer.

Copy from the floppy to her Office\Library folder.

It will appear in her list of ToolsAdd-ins.

As far as the custom toolbars and menu items goes, there is no easy way to do
this without transferring your Excelx.xlb file also, which destroys any of her
customizations.

Read this google search result.

http://snipurl.com/ksoo

Dave Peterson discusses the subject in question.

And check out Jan Karel Pieterse's site for how to distribute macros.

http://www.jkp-ads.com/Articles/DistributeMacro02.htm


Gord


On Wed, 14 Dec 2005 16:30:05 -0800, pspeed
wrote:

Thank you, Gord. However, when you said 'tell her to put it into her
Office\Library' I'm not sure how to go about doing that. When it is saved as
an .xla file, will that file appear in the Tools\AddIns available dialogue
box?

I also have custom icons and custom menu bars and would like those to be
transferred also, if possible.