Disabling copy/paste hidden cells

  • Thread starter Thread starter Shawn
  • Start date Start date
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?
 
You can create a button and assign the code to it like that

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

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

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

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