protecting cells

[Tami]

i'm making a spreadsheet that needs a lot of protection as there are many
users...so i need to protect all the formulas but based on how i'm doing it,
no one can insert rows....what can i do?

 

[Gord Dibben]

How will users select which rows to insert?

You could write code that would unprotect, insert rows at user's pre-defined
selection then re-protect the sheet.

Add a button for user to hit after selecting where to insert the rows.

Sub insertrows()
ActiveSheet.Unprotect Password:="justme"
Selection.EntireRow.Insert
ActiveSheet.Protect Password:="justme"
End Sub


Gord Dibben MS Excel MVP

 

[Tami]

good idea...will try....thx

How will users select which rows to insert?

You could write code that would unprotect, insert rows at user's pre-defined
selection then re-protect the sheet.

Add a button for user to hit after selecting where to insert the rows.

Sub insertrows()
ActiveSheet.Unprotect Password:="justme"
Selection.EntireRow.Insert
ActiveSheet.Protect Password:="justme"
End Sub


Gord Dibben MS Excel MVP