Answer the question
In order to leave comments, you need to log in
Excel: how to open a specific sheet depending on the password?
Task: there are 5 pages with different content, and depending on the password, it is necessary to open a certain page, but in such a way that the rest of the pages are hidden.
Answer the question
In order to leave comments, you need to log in
In fact, gutting an Excel file with a password is not a problem.
In your case, I would make a file with hidden sheets (veryHidden) and a macro. Display sheets - when entering a password that requires a macro. But I repeat - this is protection from a non-specialist.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question