I am trying to lock a workbook to prevent users from editing the workbook.
1) If I use the workbook protect method, I cannot add worksheets etc as expected but I can still edit the workbook.
workbook.Protect( ProtectionType.All, _loggedOnUser.GUID);
2) I have tried locking all columns of a given worksheet and then protecting the sheet but I can still edit the sheet. Any Ideas on how I can achieve my desired end.