Password Form with protected sheet

1) Move the DIM ws as Worksheet line down into the macro itself, not above it.
2) What is the problem?

The position of the Dim ws line will not cause a problem in this code.

The code merely hides all sheets except a warning sheet, probably based on some sort of password being required, with a maximum of 5 attempts. I can't see where the sheet protection is used, nor what formula you mean.

The code has been changed considerably. The original doesnot attempt to change values in the sheet because it doesn't store the number of attempts except in the code. If the sheet is protected then you won't be able to change the value without unprotecting it first

As I said, you can't chage the value on the sheet without unprotecting it. There's no reason to have anything on that sheet that can cause problems if changed, the original example didn't. You've changed the code to store the count in by the looks of it, hence the problems.

Please Login or Register  to view this content.

here i attach password form 4, i download from u before but i already edit some layout.

sheet "Splash" i edit as welcome page have login btn and close btn. i want protect this sheet.
the when i protect this sheet got debug and i dont know where to put your code given.

2nd, after some user login using their password, how to make focus to their sheet. example sheet "Jeck"

3rd, i want sheet "jeck" link to others sheet but that user cannot direct click other sheet on tab must use button on their sheet only.

all scenario i already put on attachment file. i just need solution how to make this excel smarter and secure.