Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protect worksheet - prevent changes to unlock cells formatting
Hi,
I need to protect a worksheet with some cells still being able to input/amend data. However, I need to control these unlocked cells to retain its formatting. It should allows only updating of data into the cells. Should the user copy and paste the data from other sources, these cells should still retain its formatting. Could this be done without VB? Many thanks in advance. Regards, CS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros to protect worksheet and prevent locked cell selection | Excel Discussion (Misc queries) | |||
protect cells in excel to prevent users from deleting formulae | Excel Discussion (Misc queries) | |||
Prevent User to unlock Sheet Tabs | 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 | |||
Prevent formatting Cells with Protection | Excel Programming |