View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default 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