Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protection
Hi all,
I have a sheet which runs a macro. Basically, I have a button which inserts a new line for data entry. I want to restrict modification on the sheet by the users so I have protected the sheet but have unlocked the cells that can be changed. However, when I press the button to insert a new row, it errors on me. Any suggestions as to how I can protect the sheet but allow a new item to be inserted by using the button? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protection
at the start of the sub enter ActiveSheet.Unprotect password:="whatever" at the end enter ActiveSheet.protect password:="whatever" -- irishboyx ------------------------------------------------------------------------ irishboyx's Profile: http://www.excelforum.com/member.php...o&userid=32498 View this thread: http://www.excelforum.com/showthread...hreadid=523162 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protection
Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Bug in Worksheet protection? | Excel Discussion (Misc queries) |