+ Reply to Thread
Results 1 to 6 of 6

To Call 2 macros

Hybrid View

  1. #1
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Code looks ok to me

    How are you running your macro?
    If it is from a button on a sheet you may have the properties for the button set to takefocusonclick = true instead of = false

  2. #2
    Registered User
    Join Date
    11-13-2006
    Location
    Sydney Australia
    Posts
    4
    orginally i just made a macro saying

    Sub OpenfrmEmployeeDetails()
        frmEmployeeDetails.Show
    End Sub
    When i opened the sheet, i then clicked on 'run macro' in the Visual Basic toolbar & selected OpenfrmEmployeeDetails()

    This popped up the form & away i went.

    Now i'd like to call the macros, to build the timesheet & run the form, from one macro.

    Thanks

  3. #3
    Registered User
    Join Date
    11-13-2006
    Location
    Sydney Australia
    Posts
    4
    ahhh
    dont worry about me.
    Just realised i was calling the wrong macro.
    i had 'another' macro that 'opened' the input form.
    so
    the solution was

    Sub StartUp()
    OpenfrmEmployeeDetails
    AutoWreckers
    End Sub
    ahh it was so simple its stupid
    Thanks for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1