Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Dear experts,
In a worksheet, from A2 to E200 is the range for users to fill in. Each row is an application record and users will fill into it. I will approve each record in column F by a word "approved". After I entered this word and saved the file, I want that record and above record(s) will be protected by a password "done" so that no users can edit the details of approved records anymore except me. Is it require a VBA code? If yes, please advise what is the code. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Protection | Excel Discussion (Misc queries) | |||
Protection | Excel Discussion (Misc queries) |