To Call 2 macros

Hi all,
i couldnt find anything relating to this in previous threads & was wondering if anyone could shed somelight on this.

I have a macro that builds a TimeSheet. [named AutoWrecker]
I have another macro that is a User Input form [named frmEmployeeDetails]

When i run the form , you input a name & hours worked & it sends the data to
the TimeSheet. Easy.

but i now have to make a macro named 'startup' , that will call both of these macros.
not knowing much about this, i just assumed it was:

Sub Startup()
Call AutoWreckers
Call FrmEmployeeDetails.Show
EndSub

This obviously opens both the macros, but there in no longer communication between them. When data in inputted now, it is no longer sent to the timesheet.
Is anyone able to clarify what i need to add ?.
Thanks in advance

napalm

You will need to post your code for the 2 macros so that we can see why it is failing

Right, sorry about that.
napalm



Autowreckers TimeSheet

Please Login or Register  to view this content.

Code for Input Form

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

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

Please Login or Register  to view this content.

ahh it was so simple its stupid
Thanks for your help