Hi,
In my excel worksheet, I want to protect the worksheet so that the user won't be able to change the entry in the locked cells. I manage to achieve this by using :
sheet.Protect(ProtectionType.Contents, "password","");
By using this, the cells will be locked, but it also prevents me to hide the rows while the sheet is protected. Is there any way to enable user to hide/unhide the rows while the sheet is still protected? How do I achieve that?
Thanks for your advise.