Checking the state of the Scribble tool

[mark]

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

 

[NickHK]

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

 

[Peter T]

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]

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