Application.CommandBars.ActionControl
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"spIky haIred"
wrote in message
Hi all,
How do I pick up the name of a custom toolbar item when it is clicked?
I would like to use it the toolbar for navigation purposes in a
similar way I would if it was called from a button, e.g.

Public Sub GoToSheet()
Worksheets(Application.Caller).Activate
End Sub

If I use this behind a button on a toolbar it will fail.. is there
another way to do it?
Thanks.