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.

There's no attachment

Attached

Thanks Phil.

Hi Vic,

I don't have any issues adding data to that workbook or adding/deleting columns.

The issue seems to be specific to whatever setup you have at your end so I'm not sure what else we can do for you.

As the sheets are not protected I don't see how your UnprotectAll macro affects things, and makes it work for you.  If unprotecting the sheets makes it work for some reason, that implies that they are somehow protected.

Phil

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, I can use any macro and it will work fine even if i didnt use the UnprotectAll macro. Just any macro.

Thanks again for the help. I appreciate everybody's contribution.

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

Hi Vic

Try this. I have added another field to the Setup

Just make sure that the sheet name exist

Sunny

Thanks so much sunny.

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

Thanks

Vic

Hi Vic

Thanks for your feedback.

Glad to know it is working for you.

Sunny

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

Hi Vic

There is no attachment.

hello sunny,

Pls forgive me. I thought i was able to attach the file successfully. I have been trying to attach the .xlsm file but it is not working. only the .xls is working.

Kindly follow this link to download the file. Thanks

https://transfernow.net/209wc1o9ee18

Vic

Hi Vic,

Not sure why you can't attach a .xlsm, there is no restriction on such files and I never have any issues.  Are you getting an error message?

Regards

Phil

Hi Vic

Give this a try.

Please note that since there are no error checking on whether the sheet name you allocated exist, make sure it exist. Otherwise an error will occur.

Max sheet allocation is currently 5. You will need to amend the codes if you need more.

Good luck.

Sunny

Hello Phil, yes I got an error message when i was trying to attach the file.

Sunny, thanks once again. I am grateful. it is working now.

Warm regards,

Vic