Is there a way to check the state (on or off) of the scribble tool and if
off, turn it on. Also when using, normally it turns off when you release
the mouse button. I need it to stay on until a button is clicked. so the
state would be check and automaticall turned on until a button is clicked to
turn it off.

Is this possible with code...if so, any ideas on the code?

Thanks

Mark,
If you know the points that are required to produce your scribble, you could
run code to create it.
However, Excel does not natively expose the mouse coordinates on a WS,
although could probably fake it with API calls.
Depends what you are trying to do, but providing a <canvas> for the user
that does expose mouse coordinates (a userform) and then transfer that to
the WS as a scribble may be easier.

NickHK

"mark" <(E-Mail Removed)> wrote in message
news:4612eab9$0$27110$(E-Mail Removed)...
> Is there a way to check the state (on or off) of the scribble tool and if
> off, turn it on. Also when using, normally it turns off when you release
> the mouse button. I need it to stay on until a button is clicked. so the
> state would be check and automaticall turned on until a button is clicked
to
> turn it off.
>
> Is this possible with code...if so, any ideas on the code?
>
> Thanks
>
>

It doesn't seem possible to programatically change the automatic state of
the scribble control (ID:=409). Maybe if you drag the Lines toolbar onto the
sheet it'll save you a few clicks (grab the thin caption at the top). With
code -

Application.CommandBars("Lines").Visible = True

Regards,
Peter T


"mark" <(E-Mail Removed)> wrote in message
news:4612eab9$0$27110$(E-Mail Removed)...
> Is there a way to check the state (on or off) of the scribble tool and if
> off, turn it on. Also when using, normally it turns off when you release
> the mouse button. I need it to stay on until a button is clicked. so the
> state would be check and automaticall turned on until a button is clicked
to
> turn it off.
>
> Is this possible with code...if so, any ideas on the code?
>
> Thanks
>
>

Thanks to Peter and Nick... i guess I can stop racking my brain over this
on


"Peter T" <peter_t@discussions> wrote in message
news:(E-Mail Removed)...
> It doesn't seem possible to programatically change the automatic state of
> the scribble control (ID:=409). Maybe if you drag the Lines toolbar onto
> the
> sheet it'll save you a few clicks (grab the thin caption at the top). With
> code -
>
> Application.CommandBars("Lines").Visible = True
>
> Regards,
> Peter T
>
>
> "mark" <(E-Mail Removed)> wrote in message
> news:4612eab9$0$27110$(E-Mail Removed)...
>> Is there a way to check the state (on or off) of the scribble tool and if
>> off, turn it on. Also when using, normally it turns off when you release
>> the mouse button. I need it to stay on until a button is clicked. so
>> the
>> state would be check and automaticall turned on until a button is clicked
> to
>> turn it off.
>>
>> Is this possible with code...if so, any ideas on the code?
>>
>> Thanks
>>
>>
>
>