Protect Hidden Columns

D

Denise

I have a spreadsheet that includes a hidden column and it's protected. My
problem is if someone copies and pastes it to another book, you can open the
hidden column. How can this be avoided? I cannot PDF since it's in a public
folder and another user has the password to make changes in the hidden
column.

Thanks,
 
D

Dave Peterson

I don't think that you'll find a way to protect that top secret info in excel.

Excel's protection is really made for stopping users from overwriting cells that
contain formulas. That worksheet protection is easily broken.

So my recommendation is that if you don't want others to see the data, don't put
it in excel. Or don't share that workbook with others.
 

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

Similar Threads

copy and paste range of cells excluding hidden data in excel 3
Expand and Shrink Rows and columns to hide information. 1
HIDDEN ROWS 6
Cannot unhide the hidden rows in my spreadsheet 3
How to keep hidden columns hidden using protection 1
how do i copy/paste in excel without pasting hidden lines 1
Column A is Off-screen (no, it's not hidden) 6
Protect Hidden Columns and Rows 1

Top