View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William DeLeo William DeLeo is offline
external usenet poster
 
Posts: 1
Default Set Enable = False without selecting?

Hello all,

Can someone tell me how I can rewrite the following commands so tha
the control does not need to be selected to be disabled?

Thanks!


Sheets("Sheet Name").Shapes("Drop Down 3").Select
With Selection
.Enabled = False
End Wit

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