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
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
orginally i just made a macro saying
When i opened the sheet, i then clicked on 'run macro' in the Visual Basic toolbar & selected OpenfrmEmployeeDetails()![]()
Sub OpenfrmEmployeeDetails() frmEmployeeDetails.Show End Sub
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
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
ahh it was so simple its stupid![]()
Sub StartUp() OpenfrmEmployeeDetails AutoWreckers End Sub
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks