I need a way for customers to be able to easily increase or reduce the visible rows in a protected worksheet, preferably in either of two sections of the sheet, and without them having to unprotect the sheet. Any thoughts on how this could be done?
Thanks
Peter Leach
Replies (2)
Please login or register to join the discussion.
In Excel 2003
there are a number of options that you can set to specifically allow some actions on cells on a protected sheet so you might set it there
VBA
something like
Sub Macro1()
ActiveSheet.Unprotect
Selection.EntireRow.Insert
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
will insert a row. But you will also have to deal with altering the protection of any cells requiring user input before the protection is switched back on. You could do this by copying the formats from a preformatted row.