protecting cells

  • Thread starter Thread starter Tami
  • Start date Start date
T

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?
 
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
 
good idea...will try....thx

Gord Dibben said:
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
Click to expand...
 
Back
Top