Disabling copy/paste hidden cells

[Shawn]

There is an odd quirk between Excel and Outlook in that if you copy a range
of filtered data and past the table in an Outlook e-mail and send it out, in
the e-mail sent all of the hidden rows are invisible, but when the recipient
replies or forwards the e-mail, all of the hidden cells are exposed,
defeating the puprose of filtering and only included a small subset of data.

I know there is a button to copy only visible cells, but is there a way
through excel settings or VBA to completely disable this functionality and
AWAYS only select visible rows?

 

[Roady [MVP]]

It's not Outlook doing this but apparently Excel still copies the
non-visible data to the targeted application. In your case that is Outlook
but it could be any other application as well.

That would make it an Excel question, doesn't it? ;-)
Better ask this question in an Excel newsgroup then.

 

[Shawn]

I posted the issue in Excel as well because I'm not sure if it's Excel
specific, Outlook specific, or an issue across Microsoft applications
regardless of which one you paste into.

After posting I found this (XL2000 related but clearly the problem exists in
later versions) http://support.microsoft.com/kb/245541. If that's their best
solution, there isn't a way to turn off the functionality.