Built-in password-protection souricng workbook

  • I have vlookup and a macro in a worksheet "A" that is sourcing data from another password-locked worksheet "B". is there a way i can lock these formulas and macro to avoid that anyone that enters worksheet "A" needs to input the password from worksheet "B"?