Avoid Printing the Combo Box with the Chart
 

I have a chart sheet with a combo box which I use to select the county
I'm interesting in plotting. My question for the group - is there a
way to keep the combo box from printing with the chart? Perhaps what I
need to do is simply create the chart on a worksheet and print it from
there. Just thought I would ask. Its not critical, but I thought it
would look nicer if I could leave the combo box off. I wanted to use
the chart sheet just to keep things "cleaner".

Mike

Avoid Printing the Combo Box with the Chart
 

Hi,

Right click the combo box and on the properties tab uncheck the Print
Object.

Cheers
Andy

wrote:
I have a chart sheet with a combo box which I use to select the county
I'm interesting in plotting. My question for the group - is there a
way to keep the combo box from printing with the chart? Perhaps what I
need to do is simply create the chart on a worksheet and print it from
there. Just thought I would ask. Its not critical, but I thought it
would look nicer if I could leave the combo box off. I wanted to use
the chart sheet just to keep things "cleaner".

Mike


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Avoid Printing the Combo Box with the Chart
 

You're Awesome! Thank you very much!
Andy Pope wrote:
Hi,

Right click the combo box and on the properties tab uncheck the Print
Object.

Cheers
Andy

wrote:
I have a chart sheet with a combo box which I use to select the county
I'm interesting in plotting. My question for the group - is there a
way to keep the combo box from printing with the chart? Perhaps what I
need to do is simply create the chart on a worksheet and print it from
there. Just thought I would ask. Its not critical, but I thought it
would look nicer if I could leave the combo box off. I wanted to use
the chart sheet just to keep things "cleaner".

Mike


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info