Thank you Debra and Gord..

Hiding the object was the easiest..(Tools, Options, View, Hide All).

I am practicing with Advanced Filters for another use.

Thanks again!

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Copy the visible cells to another sheet and send that out.

Alternative......

Go to ToolsOptionsView and checkmark "hide all" under the Objects
section.


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 15:08:04 -0500, "HT"
wrote:

ExcelXP

I created a chart that has a column of dates. Every week I send out the
chart and filter the column to just show one date. The drop-down button
appears next to all of the columns. I just want the results without the
ugly
drop-down button.

Please advise.

Thanks in advance...