XL2000, protected worksheet --> insert row

  • Thread starter Thread starter mika.
  • Start date Start date
M

mika.

I am using XL2000 and would like to be able to insert a
row on a protected worksheet. In ExcelXP this isn't a
problem becasue when I go to Tools --> Options --> Protect
Worksheet there are a bunch of check boxes, one of them
being insert row. But in XL2000 there is only 3 options
(Contents, Object and Scenario).

How can I get a protected worksheet in XL2000 to allow
anyone to insert a row while the worksheet is protected?

Thanks.
 
you may create a macro, which, based on the activecell
will unprotect the worksheet, insert a row, reprotect the
worksheet back again. Then you can create a button on a
freezed pane or a custom menu/toolbar that triggers this
macro.

ActiveSheet.unprotect "password"
Selection.EntireRow.Insert
ActiveSheet.Protect "password"
 
Back
Top