I know this has probably been addressed somewhere on this board. Is there an example of a custom menu that will load at time of opening the file. I need one so I can load some instructions. Thanks in advance.
I know this has probably been addressed somewhere on this board. Is there an example of a custom menu that will load at time of opening the file. I need one so I can load some instructions. Thanks in advance.
Do you want to add a menu to the Worksheet Menu Bar or do you want to make you own toolbar?
Menu item to worksheet menu bar..
Austen,
This is about the easiest resource you will ever find for making custom menus in Excel ...
http://j-walk.com/ss/excel/tips/tip53.htm
John W. did an outstanding job making this really developer friendly. I used it for my first, and it proves an invaluable learning tool.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Yeah I use the same thing. Much easier than hard coding everything for the menu.