Help me understand this code

[Carrot]

Hi everyone,

A coworker came to me with an Excel sheet with dropdown controls on it
She wanted the dropdown control to not be visible when the sheet i
printed, while the selected data in the dropdown still be printed. Eas
enough, I thought, just gotta change the combobox properties.

Turns out it wasn't quite that easy. The dropdowns seem to be create
with something that vaguely resembles XML, but isn't quite that
either. As far as I can tell, this is the code that creates th
dropdown:


Code
-------------------
<v:shape id="_x0000_s1186" type="#_x0000_t201" style='position:absolute;
margin-left:.75pt;margin-top:99.75pt;width:52.5pt;height:15.75pt;z-index:42'
stroked="f" strokecolor="windowText [64]" o:insetmode="auto">
<o:lock v:ext="edit" rotation="t" text="t"/>
<![if excel]><x:ClientData ObjectType="Drop">
<x:SizeWithCells/>
<x:AutoLine>False</x:AutoLine>
<x:FmlaLink>$AB$45</x:FmlaLink>
<x:Val>0</x:Val>
<x:Min>0</x:Min>
<x:Max>22</x:Max>
<x:Inc>1</x:Inc>
<xage>8</xage>
<xx>15</xx>
<x:FmlaRange>$AA$17:$AA$46</x:FmlaRange>
<x:Sel>0</x:Sel>
<x:SelType>Single</x:SelType>
<x:LCT>Normal</x:LCT>
<xropStyle>Combo</xropStyle>
<xropLines>8</xropLines>
</x:ClientData>
<![endif]></v:shape
-------------------


So, what the heck is this? I've had a look at the MS Office XML schem
reference, but I can't find anything that looks like this. Of course
any hint on how I can hide the control when the sheet is printed woul
be really helpful, too.

Cheers

 

[comotoman]

Try this:

Right click the combo box, 'Format Control', 'Properties' tab, and i
the bottum left is a box to 'Print Object' Deselcet it.

Let me know...

 

[Carrot]

Thanks, but I tried that. The control and its contents are not printed,
but I want the content (i.e. the selected item in the combo) to be
printed. I'm looking for something similar to the combobox property
ShowDropButtonWhen, which I could set to fmShowDropButtonWhenFocus.