• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel locking help needed

Status
Not open for further replies.
R

Rinki

Member
Hi,



I have an excel work book with multiple users entering in it and they do changes, refresh pivots and make it difficult for me to track who did what.


I want to give read only rights to all except 2 ( one is me and other is my boss)


For the 2 of us, it should give read write kind of rights and for the rest of the users it must give only read only prompt.


Let me know how to do it.
 
The easiest way:

Go to File - Save As.
In Bottom Right, Click Tools - General Options.
Input a password to modify. (optionally, also check the 'read-only recommended')
Share this password w/ boss.

Advanced option is to create a macro that runs after you open the workbook, and switches you to Read-only mode. Not my personal preference, as you have to hard code user names, and it can be defeated by simply disabling macros.
 
I am uncomfortable with macros and I dont want password.

Is there any way I can just give R/W rights only to me and my boss and rest get option view in read only mode.

Please reply at the earliest as I have to execute it in next couple of hours.
 
The only other way would be to have the file located in a folder that your IT guy has given only you and your boss write-access to.
 
Please see it cant be a secured folder bcz rest of the guys have to see the file in read only mode.
if its a secured folder, then it wont be accessible by others to see and it then it wont serve the purpose.
 
IT can set folders to have read only privileges for some users. So, default would be that everyone gets Read Only, but you and boss get Write privilege as well. They're 2 different checkboxes in IT world.

In all honestly, the password option is so much simpler.
 
hi there, I have a file ( report ) in shared location which is used by multiple sales reps people keep doing changes and I am not able to figure out like who did what in this huge report. I am interested in restricting the option for save as except for myself so that I know whatever changes have happened they are because of me only.
Please suggest some macro or some settings which could help me achieve this.
 
Status
Not open for further replies.
Back
Top