An easier way is to place a set of controls onto a Frame and set the frame's Enabled property to false.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"D.S." skrev i melding ...
Can I lock all userform controls by code upon form activation?

D.S.