random number generated password

[Jay]

Is it possible to create a password to protect a worksheet that is randomly
generated, can be stored in an area of the workbook that only I know and can
be applied within a macro so that each time the macro is run a new password
is used to protect the worksheet.

Looking to protect against users unprotecting a worksheet. These users
would not have the proficiency to figure this out if it is possible.

 

[Jim Thomlinson]

Check out this link on Passwords in XL... I personally protect sheets but
never bother with a password. Too easy to hack...

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