Free Support Forum -

Protecting worksheet


I have a requirenment in excel where I want to protect few sheets in which user cant write anything. In other sheets i want user to only write data in specific cells. The file should be protected by a password so if user unprotects it then he/she can write data in any of the worksheet.

Can we achieve this using If yes can you share some example?




Please check the document especially the sub-topic: "Protect a few Cells in the Worksheet" for your requirements:

Thank you.