Avoid Printing the Combo Box with the Chart

[[email protected]]

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]

Hi,

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

Cheers
Andy

[email protected] 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

[[email protected]]

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
>
> [email protected] 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