V
V
vetalil__182020-11-02 19:11:16
excel
vetalil__18, 2020-11-02 19:11:16

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

1 answer(s)
B
BasiC2k, 2020-11-02
@BasiC2k

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 question

Ask a Question

731 491 924 answers to any question