hidden formulas

N

neda5

I have a document that I need to send for review, but I don't want the
reviewers to see the formulas. If I hide the formulas through the Format/Cell
tab how secure is that. How easy is it for them to unlock the protection and
see the formulas?
Is there another, more secure, way?
Thanks. Neda
 
T

Trevor Shuttleworth

Depending on the level of experience of the reviewer:- Not; Very; and Not
really.

The number of unique worksheet passwords is very limited and you can find
code in these groups very quickly and easily to go through every worksheet
and unlock it.

Best way would be to take a copy of the worksheet, select all the cells,
copy them and Paste Special values. Then send them the copy. They'll only
see the results and not the calculations.

Regards

Trevor
 
A

Alan

Basically no,
Sheet passwords can be found in five minutes with code you can find on these
newsgroups. File passwords can be cracked by commercial programs that only
cost a few dollars, as can Workbook Potect passwords,
Regards,
 
N

neda5

Thanks all.
That's what I have been doing, copy and paste the values only, but my files
are llike 50megs and it takes a while to do that , so I was wondering if
there are any macros or code to make the formulas hidden that require a lot
of experience to crack.

Neda
 
Top