Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
switch on 'snap to' from vba
Does anyone out there know how to switch on the 'snap to grid' - drawing tools - using VBA? When I record a macro no code appears for this. I've tried 'msoSnapToGrid' etc etc.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
switch on 'snap to' from vba
Sub Macro4()
Dim btn As CommandBarButton Set btn = CommandBars("Drawing").FindControl(ID:=549, Recursive:=True) btn.Execute End Sub -- Regards, Tom Ogilvy "jngi" wrote in message ... Does anyone out there know how to switch on the 'snap to grid' - drawing tools - using VBA? When I record a macro no code appears for this. I've tried 'msoSnapToGrid' etc etc. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
switch on 'snap to' from vba
I knew it was done through the CommandBars object, but it's so far down in the menu tree that it took some digging to find ...
Set cb = CommandBars("Drawing").Controls(1).CommandBar.Cont rols(5)_ .CommandBar.Controls(1) if Not (cb.State = msoButtonDown) Then cb.Execute Tom Lavedas =========== "jngi" wrote: Does anyone out there know how to switch on the 'snap to grid' - drawing tools - using VBA? When I record a macro no code appears for this. I've tried 'msoSnapToGrid' etc etc. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
switch on 'snap to' from vba
I knew it was done through the CommandBars object, but it's so far down in the menu tree that it took some digging to find ...
Set cb = CommandBars("Drawing").Controls(1).CommandBar.Cont rols(5)_ .CommandBar.Controls(1) if Not (cb.State = msoButtonDown) Then cb.Execute Tom Lavedas =========== "jngi" wrote: Does anyone out there know how to switch on the 'snap to grid' - drawing tools - using VBA? When I record a macro no code appears for this. I've tried 'msoSnapToGrid' etc etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why doesn't the snap feature work in Excel? | Excel Discussion (Misc queries) | |||
Arrows don't snap vertical or horizontal | Charts and Charting in Excel | |||
A table gets updated every day, I want to take a snap shot of each | Excel Discussion (Misc queries) | |||
Excel Snap to Grid Feature | Excel Discussion (Misc queries) | |||
Very interesting problem that should be a snap to figure out! | Excel Discussion (Misc queries) |