Password Protect Individual Sheets

There no really secure method of doing this but you can use the xlVeryHidden worksheet property which means worksheets can be hidden and only made visible using VBA.

The attached example is quite basic but should give you an idea.

It uses a Control worksheet to keep a couple of lists on, one of all the worksheets in your workbook other than the Control and Front Sheet ones that may or may not need password protection and another of the sheets that you want to request a password for.

It then uses a Worksheet Change event on the Front Page sheet to check whether a password is required and display the sheet accordingly.

The last code are Workbook Open and BeforeClose events to 'very hide' all the sheets as required.

I've left the Control sheet visible but it should also be very hidden which can be set in the sheet's properties in the VBA editor and you would also need to password the VBA project to stop people seeing your password.

The code would need some refining but hopefully will point you in the right direction.

Again, anyone with the knowledge will be able to get round this quite easily but it should put most people off.

Hope it helps,

Dom