How to Determine if in Draw Mode?

[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

 

[JLGWhiz]

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.

 

[TC]

Yes, but how to determine this programmatically using VBA?

 

[Dave Peterson]

Maybe...

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

 

[TC]

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