Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Best way to deploy a macro?

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Home
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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,

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •