I have a user form that fires up when the user clicks on a command button with 'Show_Form' macro assigned to it.

the code for this is in module1 -

Sub Show_Form()

Main_Form.Show

End sub

Now, part of the procedure on the 'Main_Form' is to enter various bits of data and once validated the text boxes are locked and greyed out and the code for this is behind the user form called 'Main_Form'.

This file is then saved for another user to open and authorise.

My problem is that when the 2nd user opens the file to authorise, the text boxes are no longer locked or greyed out!!!

I have tried using .Locked = True method in code in Module1 quoted above but none of the variables are recognised.

It's late, my head hurts and I want to go home so any help to stop my brain hurting more tomorrow morning would be great.....


Thanks all