How to Determine if in Draw Mode?

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

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
 
Not sure exactly what you are asking, but if you select an item like the
arrow from the drawing toolbar and the cursor turns into a tiny plus or
crosshair, then it is in drawing mode.
 
Maybe...

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

I'm sitting here smiling because I've been fiddling with the CommandBars
myself for the past 1/2 hour.

Agreed... I think that this is the way to go.

Thanks,

Todd
 
Back
Top