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

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 visible to him? it is only the admin who can edit or add content to any sheet. If user1 is given the access to be able to see sheet1, then he should be able to work on that sheet. this is the only thing remaining now for me. Thanks so much

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 assigned to him. check and you would see. There are times that what a user enters disappears

I have attached the file for your refference. you can use user name: Admin1 & password as 123 to access the setup page. Now, user1 and user2 who have access to SRRV and SIV sheets respectively cannot work on the sheet assigned to them. Kindly help with this.

Try logging in with user1 for instance who have the right to SRRV sheet alone. then, try entering any date in A14, you would see that it doesnt even take up the table format (Try this with an Admin log in and see the difference). Also, in the same SRRV sheet for user1, enter any item code in column cell C14. You would see that it disappears immediately. the user also cannot refresh pivot table or add a column or delete a column. user1 and user2 can practically not do anything in the sheet assigned to them. This is the only problem. The login behavior and security is superb. I like this. you did a fantastic job. pls just help me correct this problem.

Thanks for your kind assistance.

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 try to enter any text in any of the empty cell. This is not happening at all. I can do these as an admin but as user1 or user2, i cannot work or do anything with the sheet. Please help. Even in the original xlsm file you posted in the forumn, the problem is there also. If you could please  work on the attachment i sent so that for user1 and user2 password 1010 and 2020 respectively can insert column, delete column, type without text disappearing . I have attached the sheet again.

Admin1  password again is 123

Thanks.

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 sheet), i can't enter any any thing in any cell, i cant edit anything in any cell. I cannot add column or delete column. I cannot do anything at all. I thought it was my version of excel (2013). I uninstalled and installed again. Same thing. I uninstalled and installed 2016, same thing. I tried opening the file in another system of two different excel versions, same thing. It is not working. when I log in with the admin, it is working fine. but with either of the users (user1 and user2), It is not working. The sheet is not protected (Kindly check the sheet again). Now, If I am on SRRV sheet or SIV sheet, and I go to the developer tab and I click on properties, If I make either of enableAutofilter = true, or enableOutling = true, or EnablePivotTable = true, then everything starts working. But when i close the file and reopen, it is back to the problem. Please look into the file very well. user1 or user2 cannot do anything please.

If possible, kindly work on the sheet for me and see that user1 and user2 can delete or inster column,row and can enter data at will.

Thanks

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 it on multiple devices with different version of excel and the problem is still there. 

The moment I log in with either user1 or user2, the first thing i do is go straight to any column (Not necessarily the table column), then I right click and click insert. It doesnt insert. If i try delete, it doesnt delete. Meanwhile these actions are happening in background to the Main sheet. The disappearing word i told you about is appearing on the main sheet. I see these when i go back to the Main sheet to log in. All the text i entered, all the column I insert and delete on the SRRV or SIV sheet which are not happening there are coming on the Main sheet. There are times that the blue login button gets expanded/stretched because of the insert i was perfoming on the SRRV or SIV sheet which is not showing there. But when I run any macro (Any macro at all - defined or not defined), it starts working well.

Sunny, please could you provide me the code that controls the login button and also the one that controls the display sheet. Maybe I should develop with another sheet. I am not too familiar with VBA so, you could teach me how to go about developing another or you could develop another with another sheet entirely for me (Not editing the sheet you gave use in the forum). Funny thing is, when i run any macro whatsoever, even macros which are not associated with unprotecting a sheet or even a macro without any code in it, the problem gets resolved. but when i close the file again, the problem starts. I even had to create a button to assign macro to it instructing the user to click the button first before they could work. unfortunately, it doesnt work even though there is not compile error. I am forced every time to go to the developer tab and run the macro from there before it works and not from the button. This also stops working when i reopen the file. I am really stuck. 

Kindly help.