Hi,
is role based security possible in excel?
Consider the following scenario: -
I have protected an excel sheet with a password say "abc". Now i want that one user, who has higher priviledges, to be able to edit that sheet without entering password. But when any other user wants to edit that sheet, the excel would show the normal message of Read Only to that user.
Is this functionality possible in Excel?
Thanx in Advance !!!
Not as a normal Excel function
You could have a macro run when the workbook is opened, The macro would check the users computer login ID and then unlock the workbook and/or worksheets if the book was opened by the accepted users
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Good morning parag kale
I have a template available that allows different users access to different parts of the same workbook on a read/write, or read only basis. This template does not automatically detect the user, the user needs to "log on" to the worksheet and it is this logon name that determines the access rights that a user has.
There is an admin function that has rights to all sheets.
If you would like to try this out, PM me your e-mail address.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks