MrExcel Publishing
Your One Stop for Excel Tips & Solutions

URGENT!! Need help with inserting rows in a protected sheet.


Posted by Tony R. Dufresne on October 05, 2001 5:54 AM

How do I insert additional rows in an unlocked area of a protected sheet without having to unprotect sheets in a workbook? I have created a workbook that includes seven password protected sheets. On each sheet I have areas of rows where data is entered and or calculated. I have unlocked that area of each sheet, and then protected the rest of the sheet; doing this for each sheet in the workbook. The workbook is made available in shared mode for those who need to enter data in their applicable sheet. I appreciate everyones help.


Posted by Tony on October 05, 2001 6:05 AM

Re: URGENT!! Need help with inserting rows in an unlocked area of a protected sheet.


Posted by P Srinivas on October 08, 2001 1:16 AM

you can put the following code to the "Insert Row" button.
ActiveSheet.Unprotect ("Optional")
Selection.EntireRow.Insert
ActiveSheet.Protect ("Optional")