On 2002-05-02 16:05, eviljamk55 wrote:
I was curious as to the best way to deploy an Excel Macro...Opinions?
GENERAL:
The deployment of your macro depends on
what your macro does and what/where you want it to operate on.
If your macro operates on just one sheet then
a button, shape or ANY object on that sheet
will suffice.
If you want your macro to operate on the
entire excel application workbooks then you
may wish to consider to deploy it from a
cutom menubar, these are also handy if you
wish to have your commands available due to
space limitations or while switching between
Sheets / Workbooks etc. Or perhaps by the use
of short cut keys.
If you want your macro to operate automatically then your need to consider
Event handlers eg Sheet/Workbook
Activate,Change,Selction change Events
or Timed events
Obviously If you made your workbook an Addin then you would need to deploy it from a
commandbar or a custom commandbar.
So in general you would need to consider
1) The user friendliness of the Macros availabilty ie. do I want immediate access to
the commands. (Button or Menu)
2) What/Where your macro operates.
(Globally or Locally)
3) If it is to be available All the time.
4) Do you need it to operate automatically
These are just general commants.