Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 menus - is this right?
Hi all,
I have developed several workbooks for clients that have specific built in menus according to the client / workbook being used and l am anxious to continue providing that facility when they upgrade to Excel 2007 I would appreciate it if the contributors to this site could confirm that l have understood the information l have read correctly. My understanding so far is as follows: 1) If l do nothing the menu item will appear in the add-in group of the ribbon. 2) Using the RibbonXL Editor available as a download from Microsoft you can: a) write XML script to add groups / menu items to the ribbon b) using the RibbonXL Editor built in functions to generate Callbacks to VBA c) write XML script to delete the groups you have added to the ribbon? Assuming my understanding is correct l have the following questions: 1) is the XML script is "attached" to the workbook, therefore when the workbook is saved, closed and re-opened the groups will be added to the ribbon. 2) the above is not dependent on the user having the RibbonXL download present? Therefore the workbook can be distributed and will still display the customised menu. 3) can the XML script be accessed via the workbook? In previous versions of XL l assume this was possible via the script editor which does not seem to be available in XL2007. 4) what exactly are XML callbacks? I originally assumed that they were commands in XML that invoked VBA macros (not exclusively). Having read / looked at Ron De Bruins examples l am not so sure. All help carification greatly appreciated. I am happy to keep this group informed about my findings / discoveries as l am sure that l am not the only one who is keen to be able to continue customising the menu .......now the ribbon Regards Michael Beckinsale |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
Excel 2007 menus - how can I get rid of them? | New Users to Excel | |||
EXCEL 2007 Menus | Excel Discussion (Misc queries) | |||
Customizing Menus in Excel 2007 | Excel Discussion (Misc queries) | |||
Menus in Excel 2007 | Excel Programming |