How to organize access control in excel?

Question

Visual Basic

Hello everyone,
there is a small enterprise - literally 4 employees.
There is an excel file containing some commercial information.
Employees must work with one excel file, but only within the framework of those sheets that they were entrusted with.
Can this be organized somehow?
I thought about issuing access to different sheets, depending on which password is entered, is this realistic?
NB: according to the conditions of the task, it is impossible to split an excel into different excel books =(

Answer 1

really
tinker with VB
PlanetExcel to help