Best way to deploy a macro?

[eviljamk55]

I was curious as to the best way to deploy an Excel Macro...Opinions?

 

[davers5]

I usually just put a button on an excel sheet and have that sheet be the only thing in that particular workbook. That will either open a user form or prompt for a file to be opened or something like that.

How do you usually accomplish this?

Dave

 

[waderw]

I usually do the same. I will have a sheet with the buttom somewhere on the sheet. The data or report will be on that sheet or some other or both. The button will prompt user for dates, filenames, or ask questions.

Regards,

 

[Ivan F Moala]

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.

 

[Corticus]

I like to assign a hotkey, like ctrl+shft+p
You can either record the macro and tell it then what hot-key activates it, or write the macro, go into the macro toolbar from Excel, choose the macro, options, and tellit then.