Macros

Deanna,

Macros created in a spreadsheet become an
integral part of the spreadsheet, once saved.
E-mailing the spreadsheet to remote users will
include the macros. The question is how do you
want the remote user to activate the macros? The
easiest way is to attach them to command buttons.
These can be added to your worksheet through the
'Forms' toolbar (click 'view'and select 'toolbars'
and check the 'Forms' toolbar). Once the toolbar
appears, click on the 'button'icon and then click
on the spreadsheet and drag to the size you want.
If the macro has been previously created, you will
be prompted to select the macro you wish to
attach to the button. There are, of course, other
ways to activate macros. Create a macro and name
it 'Auto_Open' and the macro will run every time
you open the spreadsheet. Same for 'Auto_Close',
it will activate everytime the spreadsheet is
closed.

If you already know all of this, please accept
my apologies.

Garland

Garland,

i presume her question to be of a nature in which she could distribute MACROS.

For example, I write a macro for a user.

I install it in his machine.

Later, I revise it (because of all the wonderful tricks I find here) but find it difficult to get back to his machine.

In some respects, it is hard to justify disrupting him as the previous macro works ok.

Could I instead e' (email) him a copy of the macro that would be self installing?

I believe what you may want is an Add-in. There are several MS Knowledgebase articles about this topic (keywords: addin), and this is an area I would like to explore. Essentially the Add-in you create contains all the necessary macros. The user installs the Add-in file and it become available when Excel starts. Unfortunately, I have not pursued this any further, yet!