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...