Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm looking for a way to delete unlocked cells in a worksheet without using
formulas,macro... This is the thing : locked cells are written and don't change, unlocked cells are to write on them, print and erase the context to write again of course.Also the sheet is protected with the purpose of keeping the locked cells with the text that does not change. My 2 options :1- copy the worksheet with the empty unlocked cells and write in them everytime in different sheet or 2- do what I call tab-delet, tab-delete, tab-delete until all unlocked cells are deleted ( effective but long proccess). Is there a better 3er options or I'm asking too much from excel ?TX. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock/Unlock cells | Excel Worksheet Functions | |||
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
How do I unlock specific cells in a spreadsheet that I protected? | Excel Discussion (Misc queries) | |||
How can I unlock the grouping in Excel while locking cells? | Excel Discussion (Misc queries) | |||
Lock and Unlock cells using VBA | Excel Discussion (Misc queries) |