Hello,
In a protected excel sheet some cells are unlocked to be able to put data in it.
Apparently these cells can get locked when people are copy/paste data from another workbook to these cells.
How can I avoid that this happens?
Thanks!
Bieke
Hello,
In a protected excel sheet some cells are unlocked to be able to put data in it.
Apparently these cells can get locked when people are copy/paste data from another workbook to these cells.
How can I avoid that this happens?
Thanks!
Bieke
I guess this is happening because cells in other workbook are locked
Try not allowing users to format cells in protected sheet
protect format cells.jpg
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I have tried this and cannot reproduce it. Steps:
- Format a cell to be unlocked
- Protect the sheet
- Copy a locked cell from another workbook
- Paste to the unlocked cell on the protected sheet
- The unlocked cell value is updated, and the cell remains locked
However, if the sheet is not protected, then copying a locked cell and pasting to an unlocked cell will cause the target cell to become locked.
Can you provide more detail about how these unlocked cells are getting locked?
@6StringJazzer - yes I was half asleep there - protection only works on locked cells - doh!
This is the perennial old chestnut about being unable to prevent copy paste format in isolation.
I too have been unable to re-create this problem - but that does not mean that it cannot happen under certain circumstances or in a different version of Excel
One option would be a macro to auto-run whenever the values in required "unlocked" cells are amended
- this procedure unlocks required ranges any time any one of those cells is amended
Place in sheet module:It unlocks all the cells that should be unlockedPlease Login or Register to view this content.
If you do not know the cause of the changes, you could do the same when any of the "unlocked" cells are selected
Last edited by kev_; 02-22-2018 at 01:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks