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
|