Protect Sheet - But have button to add more lines
 

When I initially protect the worksheet it will not allow the users to edit
objects or scenarios - this works great, but once I click on the button to
add more lines the protection is gone and the user can click on any object or
scenario and modify.

Can I eliminate this from happening

Thanks in advance

Linda

Protect Sheet - But have button to add more lines
 

Linda
What button? You apparently have some code (macro) linked to that button
that unprotects the sheet and adds rows, from what you say. That same code
can be written to reapply the protection. Post that code. HTH Otto

"LRay67" wrote in message
...
When I initially protect the worksheet it will not allow the users to edit
objects or scenarios - this works great, but once I click on the button to
add more lines the protection is gone and the user can click on any object
or
scenario and modify.

Can I eliminate this from happening

Thanks in advance

Linda