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.