Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, I'm not sure if anyone has explored the Beta release of Office 2007 to
be able to answer this question or not, but thought I'd give it a shot. I have an Add-In that I've developed, compatible with Excel 2000 through Excel 2003 and am looking for a way to control the order of 3 Custom Toolbars the Add-in deploys in the Add-Ins Tab of Excel 2007's "Ribbon". After quite a bit of finagling, the present code makes use of the following approach (not actually what I'm using because I had to monkey around with it and repeat some of the code because it didn't always work across all 3 Excel versions without the repetitive code, but it should suffice to convey the method): With Application.CommandBars("1st Toolbar") ..Enabled = True ..Visible = True ..Position = msoBarTop ..Left = 0 End With With Application.CommandBars("2nd Toolbar") ..Enabled = True ..Visible = True ..RowIndex = 2 ..Left = 0 End With With Application.CommandBars("3rd Toolbar") ..Enabled = True ..Visible = True ..RowIndex = msoBarRowLast ..Left = 0 End With This code is seemingly ignored in Excel 2007 and the Toolbars are deployed in a fashion I can't make sense of - I initially thought they might be sorted alphanumerically and tried renaming the toolbars to see if that was the trick, but that didn't work either. I also tried reversing the order of the code but that seemingly had no effect either. If anyone has any ideas, I'd love to hear them. Thanks, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Toolbars (Ribbons?) for Excel 2007 | Excel Discussion (Misc queries) | |||
Modify Custom Toolbars in Excel 2007 | Excel Discussion (Misc queries) | |||
Saving Custom Toolbars in Excel 2003 | Setting up and Configuration of Excel | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
toolbars keep appearing on opening excel after I removed them bef. | Excel Discussion (Misc queries) |