Excel 2007 document protection & locked cells?
Hi,
I’ve created an excel document that numerous users will be editing, however I need for only certain users to be able to edit certain cells.
I currently am using the track changes method, however it appears that there are ways around this.
Does anybody know if there is a formula or a function I can use to only allow a user to edit a certain cell if the username = joe.bloggs for example? Excel can clearly look up the username as it does so in the "track changes" but its how do i use this information to protect my cells?
Many Thanks,
Mark
Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software
Tagged with: cells • joe bloggs • many thanks • track changes
Filed under: Microsoft Excel
Like this post? Subscribe to my RSS feed and get loads more!
The Standard way is to give the password to modify the file (Save As > Tools > General Options) to those people only allowing them to edit these cells, while others can not
The other way is to lock these cells with password (Review > Protect Sheet) and give those the password
In addition to that you will always have the macro way, but that requires more info from you
Enjoy my profile, I am the VBAXLMan here