View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
spIky haIred spIky haIred is offline
external usenet poster
 
Posts: 25
Default Create generic macro for a custom toolbar

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.