Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Bars - working with the built in buttons
However once added it is disabled
I wasn't able to duplicate this. Unless of course the active sheet was a chart sheet or an XL4 macro sheet or a dialog sheet... we have been told is due to a key add-in not being able to cope with an excel11.xlb file bigger than 30KB Seems unlikely but I suppose it's easy to test if it's true. A workaround is to make your menu/toolbar customizations via macros in your Personal.xls, deleted when Personal closes or at least with the commandbars 'temporary' parameter set. That way they never hit the XLB. -- Jim "veryeavy" wrote in message ... | Hi all, | | One quick specific question re one wee oddity I have noted with the | following line of code: | | Dim btnLB3 As CommandBarButton | Set btnLB3 = | Application.CommandBars("SLBTbar").Controls.Add(Ty pe:=msoControlButton, | ID:=1561) | | which adds the "View Code" button to my custom toolbar "SLBTbar". | | However once added it is disabled when I try to use it from the workbook I | created it from, but it works fine when other workbooks are activated. | | Sure this is easy peasy and I am just being stoopid. | | | I have a general question surrounding this whole area - we have a problem at | work which we have been told is due to a key add-in not being able to cope | with an excel11.xlb file bigger than 30KB. Obviously this severely limits the | amount of customisation we can do to our toolbars. Equally obviously our IT | bods are cretins. I am not an IT bod <grin. | | I have seen the Debra Dalgleish approach using an add-in to creating custom | toolbars on the fly and also the John Walkenbach approach to saving and | retrieving menu settings to a worksheet, and realise it would not be rocket | science to create a "save and retrieve" functionality for the whole | menu/toolbar structure outside of the xlb file. | | There are obviously a number of questions: | | 1. Is it likely IT Dept talking sense with respect to a large add-in falling | over if the xlb file is too big? (i.e we can have an extensively customised | menu or the functionality of the add-in but not both). | 2. If so has anyone already designed a fully fledged workaround to save all | a users menu/toolbar settings outside of the xlb file. | 3. Any general pointers (obviously I am just messing around learning how | this stuff works at the moment) | | Cheers, | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Cell Reset Command- Built In | Excel Discussion (Misc queries) | |||
disable built-in menu and short-cut key for cut command | Excel Discussion (Misc queries) | |||
How do I set up radio buttons and slider bars in excel? | New Users to Excel | |||
Control Buttons vs. Command Buttons | Excel Programming | |||
Access a built-In command? | Excel Programming |