Hello there, im currently trying to copy and paste a protected cell from one sheet, suppose sheet 1 to a cell in sheet 2. The problem is that i have to retain the protection whilst doing so and apparently when copying the protection is lost. Is there any way of how i can copy and paste the data WITH the protection or any vba code which can be applied to carry out this task?. Thank you.
If you just do a straight copy/paste, the format (including the protection) will be copied to the destination cell.
Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks