View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Custom Menu and Menu Items

From a post by Dave Peterson.......................

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.


For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm


Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

End Dave post........................................


Gord Dibben MS Excel MVP


On Wed, 15 Aug 2007 20:08:24 -0400, "Steve" wrote:

How do I create a custom menu that opens with a specific worksheet? How do I
add menu items to the custom menu and how do I get the menu items to run
code?

Thanks!

Steve