Results 1 to 4 of 4

Thread: Deploying VBA program

  1. Jan 9th, 2006, 12:09 PM #1
    Elijah
    Elijah is offline

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    8

    Deploying VBA program

    I've written a VBA program that will be used by about a dozen people. Obviously, it would be best if they didn't have to go into the Visual Basic Editor in order to execute the program. Is there a way to just have a regular macro call the form or something? I've searched the web, these forums, and Excel help, but haven't found anything.

    Thanks.
    Reply With Quote Reply With Quote
  2. Jan 9th, 2006, 12:34 PM #2
    billhuard
    billhuard is offline
    Addicted Member
    Join Date
    Jan 2006
    Location
    Montreal, Canada
    Posts
    152

    Re: Deploying VBA program

    to execute the program on opening, put this code in ThisWorkbook:
    VB Code:
    1. Sub Workbook_Open()

    2. Call Macro1 'Can be UserForm1.Show or anything else you want to perform on opening

    3. End Sub


    If you want to execute your macro without using VB Editor
    In Excel
    Tool
    Tool->Macro
    Tool->Macro->Macro
    or Alt F8

    a new window will open with all macro available
    Last edited by billhuard; Jan 9th, 2006 at 01:04 PM.
    Reply With Quote Reply With Quote
  3. Jan 9th, 2006, 12:49 PM #3
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: Deploying VBA program

    What type of Office Application is this code written for? If it is Access you can use the Tools ===> Start Up to load a particular form when the db is opened.
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  4. Jan 9th, 2006, 03:37 PM #4
    Elijah
    Elijah is offline

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    8

    Re: Deploying VBA program

    Thank you. That subroutine does the job.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width