Protect Sheet - But have button to add more lines

  • Thread starter Thread starter LRay67
  • Start date Start date
L

LRay67

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
 
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
 
Back
Top