How to disable a form or controls at runtime

Hi,
I want to import a form for the user to view but not use. The code below uses a user selected variable to import a form (I'm using a dummy form called "Test_Form" to get the macro working) but i don't want any of the text boxes, control buttons to be active so the user can't accidentally press a form control and try to run code that isn't valid in this instance. I have code that will open the form but I cannot disable the form of the buttons. I've tried the usual "For each Control in form" approach but this doesn't work. Can anyone suggest why the line

VBA.UserForms.Add(FormExampleFileName2).Enabled = False

in the code below does't work? The macro doesn't fall over, it just carries on without disabling the form. i've put coment lines in to explain each step.

Please Login or Register  to view this content.

Thanks in advance