random number generated password

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generated text copies into another template 0
Random Password Generation 0
Password for running Macro 2
Different password for different worksheet " Help !" 1
Protecting worksheet. 1
Unprotect Workbook with Function 3
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Storing and Accessing Data 1

Top