Restrict access to different Excel worksheet for different users using VBA
Budget: €8 – €30 EUR
Hello,
I have an Excel file including 6 different worksheets, and I have 6 different users.
I need when a user Login to excel file with his username and password, he see only the worksheets which he has permission , and he should not be able to see the other worksheets he does not have permission.
I would like to be able to add new user and assign permission in the future .
would you help me ?
I cannot share my excel file , you can create an excel file with mentioned scenario and I will use the VBA code in my excel file .
I have an Excel file including 6 different worksheets, and I have 6 different users.
I need when a user Login to excel file with his username and password, he see only the worksheets which he has permission , and he should not be able to see the other worksheets he does not have permission.
I would like to be able to add new user and assign permission in the future .
would you help me ?
I cannot share my excel file , you can create an excel file with mentioned scenario and I will use the VBA code in my excel file .