Tom Ogilvy - 'Snap to'
 

Tom

How do you know, or where do you find, the ID number?

J

Tom Ogilvy - 'Snap to'
 

Try this

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 ...
Tom

How do you know, or where do you find, the ID number?

J

Tom Ogilvy - 'Snap to'
 

Sub Macro2()
Debug.Print _
CommandBars("Drawing").Controls("D&raw") _
.Controls("&Snap").Controls("To &Grid").ID
End Sub

or

Sub Macro2()
MsgBox _
CommandBars("Drawing").Controls("D&raw") _
.Controls("&Snap").Controls("To &Grid").ID
End Sub

But Ron de Bruin also posted a link to some KB articles that list ID numbers
of the controls.

--
Regards,
Tom Ogilvy

"jngi" wrote in message
...
Tom

How do you know, or where do you find, the ID number?

J

Tom Ogilvy - 'Snap to'
 

MS changed some of the ID numbers between xl97 and xl2000, so here is a
reference to the xl97 verions


http://support.microsoft.com/?id=159466
Q159466 - XL97: List of ID Numbers for Built-In Command Bar Controls

http://support.microsoft.com/?id=162814
Q162814 - XL97: Sample Macros to Return ID for a CommandBar Control

--
Regards,
Tom Ogilvy




"Tom Ogilvy" wrote in message
...
Sub Macro2()
Debug.Print _
CommandBars("Drawing").Controls("D&raw") _
.Controls("&Snap").Controls("To &Grid").ID
End Sub

or

Sub Macro2()
MsgBox _
CommandBars("Drawing").Controls("D&raw") _
.Controls("&Snap").Controls("To &Grid").ID
End Sub

But Ron de Bruin also posted a link to some KB articles that list ID
numbers
of the controls.

--
Regards,
Tom Ogilvy

"jngi" wrote in message
...
Tom

How do you know, or where do you find, the ID number?

J

Tom Ogilvy - 'Snap to'
 

Excellent fellows!

Muchos gracias!

"Ron de Bruin" wrote:

Try this

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 ...
Tom

How do you know, or where do you find, the ID number?

J

Tom Ogilvy - 'Snap to'
 

Excellent fellows!

Muchos gracias!

J

"Tom Ogilvy" wrote:

Sub Macro2()
Debug.Print _
CommandBars("Drawing").Controls("D&raw") _
.Controls("&Snap").Controls("To &Grid").ID
End Sub

or

Sub Macro2()
MsgBox _
CommandBars("Drawing").Controls("D&raw") _
.Controls("&Snap").Controls("To &Grid").ID
End Sub

But Ron de Bruin also posted a link to some KB articles that list ID numbers
of the controls.

--
Regards,
Tom Ogilvy

"jngi" wrote in message
...
Tom

How do you know, or where do you find, the ID number?

J