Forum

Vic Man
@yemrovic
Eminent Member
Joined: Jan 11, 2019
Topics: 7 / Replies: 27
Reply
RE: How to protect multiple sheet for different users

Hello house. Hello Sunny, So, in my workbook (The same i attached to my last reply up), I want user1 to have access to more than one sheet at ...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Thanks Phil. It is however surprising to me too but since it is working now with the little macro, then it is okay with me. The funny thing is...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Phil, sorry I didn't know i attached the protected one. I have removed the VBA code password in the new attachment. Thanks Phil.

6 years ago
Reply
RE: How to protect multiple sheet for different users

This is the final sheet that i added the UnprotectSheet macro. I have not tried creating another file with the code you provided. I would do ...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello everyone, Thanks for the concern as always. much grateful. Sunny, to answer your questions, 1. The sheets are not grouped ...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello everyone, This is the video link as suggested. I was not able to upload here still. Sunny, yes. I used the last file you ...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Sunny, Thanks for the prompt request. I am grateful. I have been trying to attach a video of the problem i am having but i cannot attach...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Everyone, I really appreciate your responses and contribution. However, i do not know whether or not this is a bug or something. I have tried...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Sunny, the sheet is not protected as you can see in the attached file i sent to you. when I log in with either user1(SRRV sheet) or user2(SIV...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Sunny, The problem is still the same. Try to log in with user1 and password as 1010 (Access to SRRV sheet). Then, try to insert a column or t...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Sunny, I understand you. kindly go through the sheet and you would see that a user apart from the admin, cannot work on the sheet assign...

6 years ago
Reply
RE: How to protect multiple sheet for different users

Hello Sunny, Thanks man for this. it is very helpful. Meanwhile, how do i give a user the right to be able to work on the sheet that is visibl...

6 years ago
Page 2 / 3