How to reset controls on a form after declaring them "Nothing"

[amwkl4]

Hello everyone, so I disabled my controls on the form "UserForm1" using the following code:

Please Login or Register  to view this content.

For reference, the following link is where I got the code from:
https://stackoverflow.com/questions/...ble-all-fields

However, when I go back to the UserForm1, none of the controls work anymore even when I put "ctrl.Enabled = True" in the code. What code do I need to use so the controls can have their normal functionality in UserForm1?

[ranman256]

make it more versitile by giving a parameter to turn it on or off....
usage: EnableCtrls TRUE

Please Login or Register  to view this content.

[amwkl4]

I'm not sure that would help, I have attached my code for a button associated with UserForm1 and the disable controls feature is activated upon clicking that button if the worksheet is protected.

Please Login or Register  to view this content.

If the sheet is not protected, it shouldn't run the disabling button code and the code I have in bold which re-enables the buttons should run, however when I try to use the button it still does not work and I don't know why.

[xlnitwit]

I think you want to move the Exit Sub line above the bold part so that it appears before the End If line.

[amwkl4]

Ah, that was the problem... can't believe I missed that. Thanks for your help.