Nomis_Eswod
Board Regular
- Joined
- Jul 27, 2005
- Messages
- 153
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!
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!