Allow user to edit ranges on a protected sheet

**aleenkhan** · 07-19-2012, 03:10 PM

Hello I have this code which protect the entire sheet if the name of sheet is not equal to today's date and is the name of sheet is same as todays date then it unlock the sheet to work with.

Please Login or Register  to view this content.

What I require is vba code which do the same thing but lock and unlock the range/s only. Can someone help ans I am a learner and not a proficient.?

Thanks....

**ChuckYeager** · 07-19-2012, 06:36 PM

what you would need to do is unlock the cells in the ranges that you want to edit and put the password back on, this will restrict the user to edit and update the cells that have been unlocked. so....

Please Login or Register  to view this content.

**aleenkhan** · 07-20-2012, 10:53 AM

Thanks ChuckYeager for you help.

**ChuckYeager** · 07-20-2012, 01:42 PM

You are welcome, Aleenkhan.

It gives me great satisfaction that I have been able to use my learning to help others.

**aleenkhan** · 07-26-2012, 12:20 PM

Is it possible to share this workbook so that more than one user can update it while having the same VBA code. But the above code would also try to protect the workbook structure (the line of code to protect workbook :ActiveWorkbook.Protect Password:="password", Structure:=True, Windows:=False) and Workbook protection and share can't work together . Any suggestions on this?

**ChuckYeager** · 07-27-2012, 03:27 AM

Hi Aleen,

If you try to share a workbook, it would automatically protect the structure of the workbook, as in you cannot add or delete the sheets without taking it off sharing.
Sharing would prevent you from using the protection completely, it would not allow you protect or unprotect the workbook or the worksheet.

If you have the workbook protected and then shared, the workbook will stay protected and in order unprotect, you will have to take it off sharing 1st and then unprotect it.

Regards

Chuck