Hiding Controls when printing an Excel Spreadsheet

the easiest way would be through a little VBA coding for the controls. if you're not looking for that, the second easiest way is to select the controls you don't want printed, right-click one of them and select 'format control'. on the 'properties' tabs unselect the Print Object checkbox.

with vba, do the steps above then right-click each control one at a time and select 'view code'. in the new window that pops up, you'll see your cursor between two lines of words. the code you'll need will be different from one type of control to the next. for example if your object was a command button, you'd type : 'commandbutton1.printobject = false' in between the sentences.
textbox :
textbox1.printobject = false
checkbox :
cehckbox1.printobject = false

i think you get the idea. if not just say so and i'll explain more

neo

Thanks very much neo for taking the time. That solves my problem.
Cheers.

Thanks very much neo for taking the time. That solves my problem.
Cheers Clinton.

Sorry neo, one more thing if it's OK.
What I want is for the text selected in the combo to be printed under certain conditions only. That is, the first selection in the Combo box may be N/A, which means I don't want the contents printed and if the user selects anything else from the range, then I want that printed on the form.
Could I just put an "IF" statement into the vba code to set print to false only if N/A is shown? I don't know how to do the code so if you can help, it would be appreciated.
Thanks,
Clinton.

sorry i didn't see this until now... here's what you're looking for:

if combobox1.text = "#N/A" then
combobox1.pritobject = false
else
combobox1.printobject = true
end if

neo

Sorry, I've been away. Thanks very much again for taking the trouble.

Cheers,

Clinton.