Hello, so i have a problem with copying and pasting data into a protected sheet. I have cells that are locked and i have cells that are unlocked. The cells that are unlocked get locked automatically when you copy and paste something from a different sheet.
Is there any way to prevent this??... (i want the cells to stay unlocked)
Copy and paste VALUES into the cells.
Otherwise if you copy LOCKED cells then that property is copied as well.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Awesome thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks