CAN YOU REALLY PROTECT A WORKSHEET?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IF YOU HAVE A WORKSHEET WITH HIDDEN COLUMNS THAT YOU WISH TO PUBLISH WITHOUT
THE REVIEWER SEEING HIDDEN INFORMATION YOU WOULD PROTECT THE WORKSHEET.
HOWEVER IF YOU THE COPY THE PROTECTED SHEET INTO ANOTHER WORKSHEET YOU CAN
UNHIDE EVERYTHING. HAS ANYBODY ELSE HAD THIS PROBLEM AND HAVE YOU MANAGED TO
SOLVE IT?
 
I've solved it by not putting anything in an excel workbook that I don't want
others to see--but if I have to, I don't share the workbook with anyone.

Excel's security isn't made for this kind of protection.
 
Yes, correct way to do is:
Steps to hide column and protect sheet so that nobody can open hidden columns.
STEPS













1)
FIRST MAKE COLUMN SIZE ZERO
GO TO
FORMAT






COLUMN






WIDTH = ZERO



2)
HIDE COLUMN
GO TO
FORMAT






COLUMN






HIDE



3)
PROTECT CELLS
GOT TO
FORMAT






CELL






PROTECTION





CHECK BOTH BOXES
LOCKED & HIDDEN BOX






OK



4)
NOW PROTECT SHEET

TOOLS






PROTECTION






PROTECT SHEET






ENTER PASSWORD TO UNPROTECT SHEET

5)
FINAL SETP

SAVE FILE
 
Back
Top