unlock tab upon password entry

[michael35]

Hi. Need some help on the below sequence.

I have sheet 1, 2, 3 and sheet 4. The tabs should be visible at it is on the sample. At any point of time the sheet that I had unlocked last should remain unlocked till i unlock another sheet. For example

When I click on sheet1 which has been unlocked, sheet2, sheet3 and sheet4 remains locked.
After which when i click on sheet2, without displaying the sheet first, a password prompter message box should display to input password. When I enter the right password, Sheet2 should display and remain unlock. Sheet1 gets locked together with sheet3 and sheet4.
the next sequence is When i click on sheet3, without displaying the sheet first, a password prompter message box should display to input password. When I enter the right password, Sheet3 should display and remain unlock. Sheet1 gets locked together with sheet2 and sheet4.

If an incorrect password is keyed, a message error should prompt with buttons to enter or close the message box.

[Joske920]

Hi,

Maybe this gets you started

Put this in every sheet code area

Please Login or Register  to view this content.

this needs to go in the thisworkbook code area

Please Login or Register  to view this content.

This needs to go in a Module

Please Login or Register  to view this content.