MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Once again, I've posed a problem that can not be answered.

Posted by Tony on October 08, 2001 8:20 AM

Once again, I have posed a problem that no one is able to give an answer to. Scroll down in this message board to see my post: URGENT!! PLEASE!! Need help with inserting rows in an unlocked area of a protected sheet, without unprotecting the
sheet. - Tony 16:11:26 10/06/01 (0) In fact no one has even been able to tell me that I can not insert additional rows in an unlocked area of a protected sheet, and that the only way to do it is to unprotect the sheet.

Posted by Juan Pablo on October 08, 2001 9:34 AM

Ok, try this....

There is one thing that enables you to EXECUTE MACROS, in which you can insert o remove rows, columns, whatever you want, WITHOUT removing the protection fromt the sheets.

Use a macro like this (In your Workbook module)

Const PW = "aaron"

Private Sub Workbook_Open()
For Each sht In ActiveWorkbook.Sheets
ActiveSheet.Protect _
password:=PW, _
DrawingObjects:=True, _
Contents:=True, _
Scenarios:=True, _
UserInterfaceOnly:=True 'This is the important one.
Next sht
End Sub

If you want an example, check out


Juan Pablo