Is it possible to do a VLOOKUP(or any other formula) on a password protected Workbook?
Cause I want to let people see some information inside the database(external .ods file), but I don’t want them to know all the information or open my database.
Maybe using a macro?
If you are talking of a ods-document protected via ‘Tools’ > ‘Protect Spreadsheet—’ > ‘Protect Document’ you can, but the protection is weak.
If you are talking of a document protected by encryption with a password via ‘Save As…’, ‘Save with password’ enabled, you can’t.
Any method to circumvent this would require to use a helper program or routine having access to the pasword used for the encryption in one or another way. And for the working of formulae needing permanent access to data (not only when loading) the encrypted document or a kind of copy of it (probably to RAM) must stay opened.
To be able to manage rights more detailed you will need a full-grown database system,I think. Otherwise you would have to program a lot of tools on your own.
It’s not something tooo important, I just want to create my spreadsheet like an interface to show some data to my clients, It will not be a big issue if they crack it.
What about a macro to open the password-protected Workbook in the background and then run the VLOOKUP on it?