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.

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.

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.

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.

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.

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.