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.