autoselect freehand-tool (shapes)

[wamp]

question in short:
Is it possible to write a macro that auto-selects the freehand-tool for you?
as in: "run macro, then start drawing?"
(see attached image for which tool I mean(note: norwegian excel))

Why do I want to do this?
I have created a userform that, among a lot of other things, has an image-container that serves as a signature field.
When a user clicks on the image-container, the userform hides and they are directed to an excel-sheet called "signature"

the problem is that the user then have to manually click on the drawing-toolbar, select "Autofigures" - "Lines" - "Freehandform" to be able to start signing (or drawing).


(once they've done drawing/signing (creating a shape), they click a button that converts the shape into an image, then pastes it into the imagecontainer in the userform, so everything else works "automatic")

[romperstomper]

I'm guessing you want the Scribble control for a signature, rather than the Freeform, so:

Please Login or Register  to view this content.

[wamp]

ahh.. purrfect.

by any chance, do you know of a list of the control ID's? (scribble is id 409, but how could I figure that out?)

[DonkeyOte]

You might be interested in: http://www.rondebruin.nl/menuid.htm

[wamp]

bookmarked!

thanks

[romperstomper]

I use this code:

Please Login or Register  to view this content.

[romperstomper]

Forgot the additional funcs:

Please Login or Register  to view this content.

[romperstomper]

And if you want the pictures too:

Please Login or Register  to view this content.

[novalisvolk]

Hey guys,
I need some advice.
I just added the line:

Please Login or Register  to view this content.

into the macro connected to the button. Now if I click on the button, the arrow of the mouse chances into a pencil, so far so good but I cant draw anything into my worksheet. What do I need to do to solve the problem. I have no idea about VB.

Thanks