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: 177
Default Creating gallery in dynamic menu

I'm trying to create a dynamic gallery control within a dynamic menu item in
my XL2007 ribbon tab. What I'm trying to create is something that looks
like Excel's Format as Table or Cell Styles controls on the Home tab. That
is, when the control is activated I want a menu with separators and then I
want a single gallery control within following each separator that shows the
gallery images.

In my experimentation the closest I can get to this is something that looks
like the Conditional Formatting control. That is menu separators with menu
entries that then expand to the gallery.

I can get the desired appearance in my menu if I substitute button controls
for the gallery items ... but button controls don't give me the
functionality I want. In particular I want decent size images that I can
control using the itemHeight and itemWidth attributes.

The way I'm doing this is I've added a single dynamicMenu control to my
custom tab that has a getContent that points to a routine that I've written
to generate the XML.

This routine generates:

- The schema header.
- A menu separator
- A gallery control which itself is defined using getItemCount, getItemID,
etc.
- The needed XML closure tags.

The middle two steps are repeated as necessary based on external data.

I've tried generating the gallery control with and without a Label attribute
thinking the lack of a label or a top level image might cause the generated
ribbon entries to be pulled inline to the menu but no joy.

Anybody got any suggestions?

TIA,

josh


 
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
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function [email protected] Excel Programming 0 October 9th 07 05:22 PM
Macro creating chart gallery giving problem Pranav Vaidya Excel Programming 0 August 8th 07 12:04 PM
Macro creating chart gallery giving problem Pranav Vaidya Charts and Charting in Excel 0 August 8th 07 12:02 PM
dynamic pull down menu Kia Fluker Excel Programming 0 June 24th 05 05:06 PM
dynamic value insertion - possible with menu?? Rubble[_2_] Excel Programming 0 September 16th 03 01:27 AM


All times are GMT +1. The time now is 10:23 PM.

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

About Us

"It's about Microsoft Excel"