Forum Discussion
Solved
Protect Sheet
Hello.. I have a workbook that has around 50 tabs within it. Another individual is responsible for updating approximately 5-8 cells/rows for 30 of those tabs, while I am responsible for the rest of i...
You can specify those options in the code. If you don't, they'll be disabled by default:
wSheet.Protect Password:=Pwd, DrawingObjects:=True, Contents:=True, Scenarios:=True, _ AllowFormattingCells:=True, AllowFormattingColumns:=True, _ AllowFormattingRows:=True, AllowInsertingRows:=True
You can specify those options in the code. If you don't, they'll be disabled by default:
wSheet.Protect Password:=Pwd, DrawingObjects:=True, Contents:=True, Scenarios:=True, _
AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowInsertingRows:=True- Hans, my man!!!!! Thank you soo much! I previously tried this but must have had something wrong in my code because it gave me an error.
Thank you very much!- I wish to protect a sheet such that only SELECT UNLOCKED CELLS, INSERT ROWS and DELETE ROWS is permitted. But when I do this, the INSERT ROWS and DELETE ROWS permission does not take effect, and I cannot do either.
On the Home tab of the ribbon, in the Cells group, the Insert drop-down will look grayed out, but you can still select it and select Insert Sheet Rows.
This doesn't work for the Delete drop-down though. You can only delete a row if ALL cells in that row are unlocked. Right-click the row number to select the entire row, then select Delete from the context menu.
All this is easier if you allow locked cells to be selected.
