Thread: Set Enable = False without selecting?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
  
Posts: 226
Default Set Enable = False without selecting?
Actually, neither, you have to set it yourself:

Sheets("Sheet Name").Shapes("Drop Down 3").Enabled = False

or

Sheets("Sheet Name").Shapes("Drop Down 3").Enabled = True

--
Regards

Juan Pablo González

"William DeLeo " wrote in
message ...
Thanks for the quick reply!

Q: That command will DIS-able the control or EN-able it?

I need to be able to do both ...

Thanks again


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote