View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Office_Novice Office_Novice is offline
external usenet poster
 
Posts: 245
Default 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