And how would that prevent data from being copied into another blank
sheet?

Pete

On Dec 21, 9:16*pm, Avora wrote:
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



"JONNY ZERO" wrote:
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?- Hide quoted text -

- Show quoted text -