Disabling copy/paste hidden cells

S

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?
 
I

igorek

You can create a button and assign the code to it like that

With Selection
.SpecialCells(xlCellTypeVisible).Select
.Copy
End With

Regards.
 
S

Shawn

Good idea, is that the same as the shortcut "ALT + ;"? Which, if you select a
range then press, selects only visible cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top