LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 274
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub-menus of main menus for Excel 2007 Eleanor Peppard New Users to Excel 1 March 16th 10 04:12 PM
Excel 2007 menus - how can I get rid of them? Vic Baron New Users to Excel 4 August 21st 08 04:15 PM
EXCEL 2007 Menus Marvin Buzz Excel Discussion (Misc queries) 1 May 22nd 08 04:39 PM
Customizing Menus in Excel 2007 Loris Excel Discussion (Misc queries) 1 February 11th 08 10:52 PM
Menus in Excel 2007 Geoff Excel Programming 20 September 21st 06 06:34 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"