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.

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?

--

Dave Peterson

Yes, others have seen this. It's not possible to protect a
worksheet/workbook to prevent seeing hidden information.

See:

http://www.mcgimpsey.com/excel/removepwords.html

If you want to keep hidden information hidden, send a PDF file.



In article ,
JONNY ZERO <JONNY 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?

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?

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 -