Password access to sheet - have code need help improving

[lukestkd]

Hi all,
I've found the following code on the net which seems to do the job for me (I want to users to require a password to access a sheet in my wb).

However, if you click cancel when you have clicked on tab ProgressCompCriteria (e.g. you don't have the password and are cancelling off) the whole wb closes. I want it to return to sheet 'Menu' instead.

Cheers, Luke [ATTACH](file here)212679[/ATTACH]

Please Login or Register  to view this content.

[mc84excel]

tab ProgressCompCriteria

No tab named ProgressCompCriteria. Did you mean "PercentCompCriteria" instead? Or could the "ProgressCompCriteria" tab have been deleted?

[mc84excel]

Assuming you meant the tab "PercentCompCriteria" then go the 'ThisWorkbook' module and replace the Workbook_SheetActivate code with the one below:

Please Login or Register  to view this content.

[mc84excel]

I should warn you that this code is not very secure. It can be easily bypassed if the end user refuses to enable macros. (You could work around this by forcing users to enable macros but that's a topic for another thread).

[lukestkd]

I should warn you that this code is not very secure. It can be easily bypassed if the end user refuses to enable macros. (You could work around this by forcing users to enable macros but that's a topic for another thread).

Works perfectly for what I need! Many thanks for this mc!

[mc84excel]

Works perfectly for what I need! Many thanks for this mc!

Glad to help.

(Just as long as you are aware that this password protection is extremely insecure. It can be broken quite easily and - if the end user did not enable macros when opening the workbook - even bypassed accidentally).