ComboBoxes

[Nomis_Eswod]

Hi,

I have a spreadsheet that has 4 comboboxes on it, from the control toolbox. Whenever I try and print the spreadsheet, these boxes dramatically shrink in size.

Any ideas why this might be? I do actually use a macro to print each worksheet, so that it can be done from 1 'control page'. To combat this, I was trying to build something into the print macro, like ComboBox1.Height = "19.5", but it didn't recognise the control.

Any other bright ideas on how to fix it?

Thanks!

 

[Andrew Poulsom]

Is it this?

http://support.microsoft.com/default.aspx?scid=kb;en-us;838910

 

[Nomis_Eswod]

Looks like it could be! Did what it said and it printed ok!

I tried changing the properties the other way, thinking it might be the fact that it was over a cell causing it to print like that for the opposite reason, so I had it on don't move or resize!

Thanks for the help!