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?
If you want to keep hidden information hidden, send a PDF file.
In article <80D7D772-9D0B-4B6F-A929-61E41F901690@microsoft.com>,
JONNY ZERO <JONNY ZERO@discussions.microsoft.com> 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?
Question
Reply
Top
Answer
Notify me of replies