Hi all, here is my problem that i made into an example form:

I have a restaurant that has two excel files, one is the ORDER SHEET and one is the RESTAURANT DATABASE files. The order sheet gets filled up by the employees in the restaurant and that file calls up data from the RESTAURANT DATABASE files by using VLOOKUP. But the RESTAURANT DATABASE file is password protected and the employees dont know the password. The problem here is that when the employees fill up the order sheet the file will ask the password of RESTAURANT DATABASE. Is there a macro around this that when they're in the order sheet and there's a password prompt there will be a macro to override the password. So basically im asking for a way to make them able to input a password whenever they are prompt in the order sheet but not be able to know what the password is, is this possible?






Here is an example to help:
excel forum restaurant order sheet.xlsx
restaurant database.xlsx

The password for the database is abc123
I apologize since the VLOOKUPS on the order sheet will not work since the links are localized in my computer, If there was anyway i can make it downloadable and the vlookups accessible without editing it i would but i dont know how.

So in the order sheet, the employee types either HTDG, TCO, HMBRG, FRNCHF in the item code column and the columns beside it are the ones that are vlookup-ed to the database. But if you do that without opening the database file it would prompt for a password, so here is where i'd like a macro that can override the password so they can use the order sheet freely, but still be blocked from the database file. I hope someone can help in any way, thanks.