ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disable objects on form (https://www.excelbanter.com/excel-programming/409752-disable-objects-form.html)

ranswrt

disable objects on form
 
I have a userform with a lot of labels, buttons, etc. Is there a code I can
that can be used that will set ".enabled = false" for the group of objects
instead of doing each one individually?
I don't want to disable the whole userform.
Thanks

Office_Novice

disable objects on form
 
Try putting the Labels you want disabled in a frame control then disable it.

"ranswrt" wrote:

I have a userform with a lot of labels, buttons, etc. Is there a code I can
that can be used that will set ".enabled = false" for the group of objects
instead of doing each one individually?
I don't want to disable the whole userform.
Thanks



All times are GMT +1. The time now is 01:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com