We are distributing an Excel .xlsx file with password protected worksheets (formulae and calculations must be invisible to the users).
Also we would like to hide some of the worksheets, so that they can't be un-hidden. I know about the "xlVeryHidden" option in the VBA editor, but anyone who knows just a little of Excel can get in and change this back without a password.
So the question is can a non-macro worksheet be hidden with password protection? Also I get the feeling the Excel protection isn't that amazing and that anyone determined to get in and see the spreadsheet details wouldn't have that much trouble.