Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Button or Auto Protect Formula | Excel Worksheet Functions | |||
password protect the button in Excel? | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
How to protect option button? | Excel Worksheet Functions | |||
How to protect Option button in worksheet | Excel Worksheet Functions |