Disabling and Enabling a Userform

[java568]

If I do the following when a button clicks in a userform on Excel '07:

Me.Enable = False
 
'-----any type of code or even blank----'
 
Me.Enable = True '<---- Does not work

How come the second enable doesn't work? This seems to be the case regardless of the type of code between the two statements.

 

[Norie]

IE automation calls?

 

[java568]

IE automation calls?

You have to be trolling me...

Can we get back to the important question at hand?

If a userform is set to userform.enabled = false, why does every line of code within the userform continue to run perfectly expect for userform.enabled = true? It's not because the userform is disabled, or else no lines or code would work. Enabled has to do with user interface and does not affect code function with any objects that it applies to.

 

[Norie]

Sorry I don't know what 'trolling' means.

If I've offended you in anyway I apologise.

I'm just trying to help.

 

[kpark91]

Hi, I've looked around in the internet and everybody seems to be having the same problem as you.
I think the best way to approach this is to have a checkbox that allows the user to "enable" and "disable" the userform by locking or unlocking all the controls inside the userform.