snap to from vba

jngi · Jun 18, 2004

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.

Ron de Bruin · Jun 18, 2004

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 said:
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.

Tom Ogilvy · Jun 18, 2004

answer provided to your first posting of this question.

--
Regards,
Tom Ogilvy

jngi said:
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.

jngi · Jun 18, 2004

Got it!

Thanks

Tom Ogilvy said:
answer provided to your first posting of this question.

--
Regards,
Tom Ogilvy

tools - using VBA? When I record a macro no code appears for this. I've
tried 'msoSnapToGrid' etc etc.

jngi · Jun 18, 2004

Its OK Ron. Tom Ogilvy sorted it out

Thanks for the reply

J

Ron de Bruin · Jun 18, 2004

I know it now<g>

If you want to know the ID numbers of all controls
http://support.microsoft.com/default.aspx?scid=kb;EN-US;213552
XL2000: List of ID Numbers for Built-In CommandBar Controls
http://support.microsoft.com/default.aspx?scid=kb;en-us;213211&Product=xlw
XL2000: Sample Macros to Return ID for a CommandBar Control