Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Dear experts,
I've a worksheet where a range A5:D100 is for some users to fill in information. Is there a way when the cell is blank, it can be input by any users. However, whenver an user fill in some information to some rows within the range, the non-blank cells will be protected by a password, say "tiptoe" after saved but other blank cells will still be unprotected and can be input by other users. Is there a VBA code can do this? If yes, please kindly advise the code. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect spreadsheet from being saved | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Password Protect When Saved | Excel Discussion (Misc queries) | |||
How can I see a copy of a saved workbook before I saved it again? | Excel Worksheet Functions | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |