Is there anyway I can program a menu to be attached to an excel toolbar every time my program runs. Right now I created a menu bar in excel (tools, customize) and I attached a macro to it. The macro calls my form and the program runs. But when I give this program over to the user, they won't have the correct menu items in excel to run the program. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
toolbar
- Thread starter sf123
- Start date
RobBroekhuis
Technical User
You'll need to manipulate the application.commandbars object, probably from the Workbook.Open event handler. If that sounds like gibberish, then you probably need to invest in a basic Excel VBA programming book - we could help you with some basic code, but you'll need to really understand it to be able to make it work just the way you want it.
Rob
Rob
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question