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.

"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
>
>
>

Yes, but how to determine this programmatically using VBA?


"JLGWhiz" <(E-Mail Removed)> wrote in message
news:85369FAE-D235-479F-8303-(E-Mail Removed)...
> 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" 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
>>
>>
>>

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

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


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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