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 is printed, while the selected data in the dropdown still be printed. Easy enough, I thought, just gotta change the combobox properties.

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

Please Login or Register  to view this content.

So, what the heck is this? I've had a look at the MS Office XML schema 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 would be really helpful, too.

Cheers!

[comotoman]

Try this:

Right click the combo box, 'Format Control', 'Properties' tab, and in 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.