View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Activate Freeform crosshairs with code - possible?

You don't need a commandbutton.

Customize Toolbars / Commandbars / Categories - AutoShapes (select)

scroll down "commands" and drag the FreeForm icon onto your drawing toolbar.

You could also add a "custom" icon next to it assigned to a macro to do
"other stuff" to the selected FreeForm (I suspect from elsewhere that's an
objective).

Regards,
Peter T

"Pierre" wrote in message
...
Hi All,
I would like to have a commandbutton on a particular Sheet that, when
clicked, the default pointer changes to crosshairs so that I can start
drawing a freeform. I e. I don't want to navigate the menu Autoshapes/
Lines/Freeform to start drawing. Is that possible?
Thanks in advance.
Pierre