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
--
HTH...
Jim Thomlinson
"Jay" wrote:
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.