Is there any ultimate password protection in Excel

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

Guest

I was amazed to see how many different ways there are to unlocking
workbooks/sheets if the password to unprotect them is not known.

I need to send a workbook to a customer, but I dont want them to see one of
the worksheets therein. I have therefore hidden the worksheet, and protected
all the worksheets and the workbook.

However, judging by some of the answers on here, my customer could have the
hidden worksheet open in seconds! What else can I do to stop him finding the
password to the workbook and unhiding everything?

Thanks,

MW
 
None whatsoever!!! If it is in a workbook then consider it public. You can
make it hard to get to but there are probably none of the regulars in here that
could not get to your data no matter what you did to it, or how hard you tried
to hide it, and that even means breaking VBA code password protection which up
until a while ago was usually the surest way of hiding data (Though never
foolproof).

If you don't want it seen then don't put it in - Anything can be hidden from
casual view but a determined person will get it without too much trouble.
 
Back
Top