User form Login

[Abdullah Al Mamun]

Hello,

I have a shared workbook in which I want to use multiple users, i ask to set a user form login have a different authorization level. There will be admin level and user level. Admin level can change and see every thing but user level can use and see only salary statement sheet. The change the admin made will be record in another worksheet like"Record".Only Admin can create new worksheet user not permited. In this worksheet the password for edit "0" Zero.

Gratefully,
______________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[xlstime]

Hey Abdullah,

Firstly, welcome to our family!!.

This is not easy and quick task to resolve, would suggest you to please go thru blow urls and let us know if need any help after this.

http://www.onlinepclearning.com/excel-userform-login-form/

https://turbofuture.com/computers/Excel-VBA-Create-A-Basic-Login-Function

I understand this is not a complete solution but this will help to kickstart

Hello,

I have a shared workbook in which I want to use multiple users, i ask to set a user form login have a different authorization level. There will be admin level and user level. Admin level can change and see every thing but user level can use and see only salary statement sheet. The change the admin made will be record in another worksheet like"Record".Only Admin can create new worksheet user not permited. In this worksheet the password for edit "0" Zero.

Gratefully,
______________________________________________________________

Mod edit : thread moved to appropriate forum !​