Protecting hidden columns so they can't be unhidden ?


G

Gary

Hi,

Is there a way to hide columns so that no one else can unhide them ? Need
to send a file with data in 2 hidden columns that I don't want to be
unhidden and I don't want to have to delete them.

Thanks !
 
Ad

Advertisements

D

DDM

Gary, easiest way is to hide the columns then protect the worksheet (Tools >
Protection > Protect Sheet). If there are cells that the recipients will use
for data entry, unlock them (Format > Cells > Protection > Locked) first.

You can also remove the row and column headers (Tools > Options > View > Row
& column headers) so it won't be immediately apparent that there are hidden
columns.
 
R

Ron de Bruin

There is no safe way to do this
You can protect your sheet but the password is easy to break.

The best way is to only send the visible data as values to them.
Is this a option?
 
Ad

Advertisements

K

Ken Wright

Most in here could break any level of protection you put on those columns in
around 12 seconds or less. If this is stuff you'd 'rather' they didn't see,
then your choice of whether to chance it, but if it's sensitive data that's in
there then I'd suggest you rethink this now. As Ron suggested, paste as values
or find another way of disguising/burying the data in a format that can't be
reverse engineered.
 

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