| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
|
|||
|
|||
|
snap to from vba
Hi jngi
'snap to grid' - drawing tools I don't know what you mean by this Can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl "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
|
|||
|
|||
|
snap to from vba
answer provided to your first posting of this question.
-- 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
snap to from vba
Got it!
Thanks "Tom Ogilvy" wrote: answer provided to your first posting of this question. -- 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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
snap to from vba
Its OK Ron. Tom Ogilvy sorted it out
Thanks for the reply J "Ron de Bruin" wrote: Hi jngi 'snap to grid' - drawing tools I don't know what you mean by this Can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl "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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
snap to from vba
I know it now<g
If you want to know the ID numbers of all controls http://support.microsoft.com/default...b;EN-US;213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default...11&Product=xlw XL2000: Sample Macros to Return ID for a CommandBar Control -- Regards Ron de Bruin http://www.rondebruin.nl "jngi" wrote in message ... Its OK Ron. Tom Ogilvy sorted it out Thanks for the reply J "Ron de Bruin" wrote: Hi jngi 'snap to grid' - drawing tools I don't know what you mean by this Can you explain more -- Regards Ron de Bruin http://www.rondebruin.nl "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. |
| 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) | |||
| Very interesting problem that should be a snap to figure out! | Excel Discussion (Misc queries) | |||
| switch on 'snap to' from vba | Excel Programming | |||
![jngi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
