ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activate Freeform crosshairs with code - possible? (https://www.excelbanter.com/excel-programming/416024-activate-freeform-crosshairs-code-possible.html)

Pierre[_19_]

Activate Freeform crosshairs with code - possible?
 
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

Peter T

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




Pierre[_19_]

Activate Freeform crosshairs with code - possible?
 
On Aug 24, 11:59*am, "Peter T" <peter_t@discussions wrote:
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- Hide quoted text -


- Show quoted text -


Thanks Peter


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com