I have a spreadsheet that utilizes many locked and unlocked cells to protect existing formulas. The table is autofiltered with a standard excel filter function and then protected. I know that on an unprotected sheet you can select a range of cells and hit [Alt + ;] to select only visible cells. This function does not work on protected sheets.

I'm looking for a way for the user to be able to copy and paste values without unprotecting the sheet and without overwriting filtered cells.