How to protect multiple sheet for different users|Page 2|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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 sent to me and that's the same file i used in creating the video.

Thanks everyone

Hello everyone,

Thanks for the concern as always. much grateful.

Sunny, to answer your questions,

1. The sheets are not grouped

2. I actually used mouse for the insertion of columns which did not work.

3. The problem did not occur when all the sheets are displayed because I was logged in as an admin and like I said before, the problem is only with user1 and user2. Admin users do not have the problem.

Hello Mynda, yes, the texts are still visible in the formula bar here. I wonder why.

Phil, 

I completely uninstalled office 2013. deleted all folders associated with it before installing office 2016 (64-Bits). I do not also have any add-ins installed.

As per the security, though this is going to be used by different users in the later days and would require the use of a server. But that is not happening now as I am currently working on my laptop (Personal Laptop) and not the company's official system. So to answer your question, there are not restriction of any kind.

I have also gone through your file Phil. Sadly, the problem is still there and I am beginning to think there is a bug issue. 

However, I did try something though which is just one extra work anyway but i am fine with it as long as it works. I created another line of code (UnprotectAllSheet) and I gave a shortcut of Shift+Ctr+U. This is developed only for User1 & User2. This code prompts the users to enter their login password to unprotect the sheet even though the sheets were not protected apart from the visibility. Its funny though but surprisingly, it works. 

Once User1 or User2 logs in, they just press the shortcut and they enter the password and they are good to go. So on the first row of the SRRV and SIV sheet, I wrote a comment for the user to do this. I will keep trying to see if I can work my way around the disappearing sheet anyway but for now, I am okay with what I have been able to come up with.

Once again, I am super super grateful for everyone who contributed to this. you are all loved. I joined this forum just recently and it has been so so active and i have received help from different people. I still have more to share with you guys soonest.

Thanks all

Vic.

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 a time. Please, how can i achieve this?

User1 should have access to SRRV and SIV sheet as the same time.

Warm regards,

Vic

Thanks so much sunny.

I knew i could count on you. I have been able to reproduce for more sheets.

Thanks

Vic

Hello Sunny,

Hope you have been good?

I have been able to work my way around the disappearing text and everything seems okay now. It turns out that there is a problem with the Anti virus been used across the network. Additionally, I started the file from scratch and i do not have the problem again. Thanks so much and everybody who have contributed.

Meanwhile, I have developed another file (Attached). In this case, I want the sheets "Dashboard" and "Daily Summary" to be visible along side "Main" by default. They should be visible the same way the "Main" sheet is - So no need to log in with a credential to view them. 

Also, I have given user1 multiple sheet to have access to but only two sheets out of the many sheets assigned to user1 is getting displayed. 

login is: Admin    Password is: 111           This will give you full right. You can type the credential as it is not coming in the drop-down.

Thanks so much