disable objects on form

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disable UserForm Objects	Sean Connery via OfficeKB.com	Microsoft Excel Programming	1	11th Nov 2006 06:29 PM
Disable/Enable Form Objects With Code	=?Utf-8?B?QWxpYXM=?=	Microsoft Access Form Coding	1	18th Nov 2005 04:24 AM
Disable and Enable objects on mass???	=?Utf-8?B?U3RldmU=?=	Microsoft Dot NET	1	17th Jun 2005 08:01 AM
using macros to disable excel objects.	=?Utf-8?B?YnVubWk=?=	Microsoft Excel Programming	0	11th May 2005 06:00 PM
Dynamically Assign Objects to Form Objects.	The Vision Thing	Microsoft Excel Programming	2	11th Dec 2004 04:02 PM