View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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