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?

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


On Mon, 2 Jun 2008 18:11:07 -0700, Tami wrote:

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?

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

"Gord Dibben" wrote:

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


On Mon, 2 Jun 2008 18:11:07 -0700, Tami wrote:

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?