Protected spreadsheet rows

Protected spreadsheet rows

Didn't find your answer?

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.

avatar
By ACDWebb
26th Jan 2007 13:46

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

Thanks (0)
avatar
By listerramjet
26th Jan 2007 13:52

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.

Thanks (0)