View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to Determine if in Draw Mode?

Maybe...

If Application.CommandBars("Drawing") _
.Controls("Select Objects").State = msoButtonDown Then
MsgBox "It's depressed"
Else
MsgBox "it's not depressed"
End If



TC wrote:

Hey All,

I was wondering if there is a way to determine when Excel is in draw mode
(i.e. click on the 'Select Objects' arrow on the Drawing toolbar)?

Thanks,

TC


--

Dave Peterson