Tom Ogilvy - 'Snap to'

[jngi]

Tom

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

J

 

[Ron de Bruin]

Try this

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

 

[Tom Ogilvy]

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.

 

[Tom Ogilvy]

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

 

[jngi]

Excellent fellows!

Muchos gracias!

Try this

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

 

[jngi]

Excellent fellows!

Muchos gracias!

J

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.