View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William DeLeo William DeLeo is offline
external usenet poster
 
Posts: 1
Default Syntax for de-selecting a control?


Greetings,

I figure this is a frequent question but I could not find a thread o
site that gives me the answer so here goes ...

I am using the follwoing code to disable a control:

Sheets("WS_12").Shapes("Drop Down 4").Select
With Selection
.Enabled = False
End With

But I need to deselect it after, or not select it at all in the firs
place. Can someone suggest a way to disable this control and leave i
unselected (without selecting something else)?

Thanks in advance!

Bill

--
William DeLe
-----------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...nfo&userid=125
View this thread: http://www.excelforum.com/showthread.php?threadid=34687