Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a toolbar
Hi folks,
I am building a toolbar to be used by staff in my office to automate certain Excel functions. I am looking to build a sheet which I will send to the staff, which they will open once and this will load the toolbar into their Excel and save the toolbar, meaning that it should appear whenever they open Excel from now on. The problem I am having is that I cannot create a menu option at the top of the Excel page (what I want is for a menu item to be created at the top named 'Toolbar', when they click this the toolbar loads into Excel). This menu works fine for me just now, however I cannot create this using VBA so that I can send a sheet to every team member to create the toolbar? Any thoughts? Any help appreciated. Will |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a toolbar
Will,
To achieve what you are looking for in your suggested way would mean altering each user's own toolbar, which they may well have customised already. It's not really a good idea. You would be much better off putting your toolbar inside an add-in, which could then be loaded permanently or on demand by your users. The add-in could also create menu entries if you wish. John Walkenbach has some code posted that shows how to do this on the fly, which appears to be the most reliable method on www.j-walk.com somewhere. Robin Hammond www.enhanceddatasystems.com "William Francis" wrote in message ... Hi folks, I am building a toolbar to be used by staff in my office to automate certain Excel functions. I am looking to build a sheet which I will send to the staff, which they will open once and this will load the toolbar into their Excel and save the toolbar, meaning that it should appear whenever they open Excel from now on. The problem I am having is that I cannot create a menu option at the top of the Excel page (what I want is for a menu item to be created at the top named 'Toolbar', when they click this the toolbar loads into Excel). This menu works fine for me just now, however I cannot create this using VBA so that I can send a sheet to every team member to create the toolbar? Any thoughts? Any help appreciated. Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a toolbar for my add-in | Excel Programming | |||
Creating a custom toolbar in VBA | Excel Programming | |||
Creating a Toolbar to add-in | Excel Programming | |||
Creating a Toolbar with a macro | Excel Programming | |||
Creating a toolbar using VBA | Excel Programming |