While pasting the Un protected Cells became Protected an locked
Closed
SALWA ATALLAH
TrowaD
- Posts
- 2
- Registration date
- Friday January 11, 2013
- Status
- Member
- Last seen
- April 20, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- While pasting the Un protected Cells became Protected an locked
- Macro copy and paste in next blank cell - Guide
- Macro copy and paste in next blank cell ✓ - Forum - Excel
- Macro that goes to next blank cell ✓ - Forum - Programming
- Copy and paste only non-blank cells with vba code ✓ - Forum - Excel
- Copy paste Rename based on cell value ✓ - Forum - Excel
2 replies
sgmpatnaik
Apr 23, 2013 at 12:50 AM
- Posts
- 54
- Registration date
- Tuesday April 2, 2013
- Status
- Member
- Last seen
- November 27, 2013
Apr 23, 2013 at 12:50 AM
@Salwa
Hi
as a blind shot when you protect the sheet did you give the Allow users to edit the range if it is not then it is not possible to paste the value in protected before Un Protect so please check
other wise please upload a sample file with your problem
Thanks
Patnaik
Hi
as a blind shot when you protect the sheet did you give the Allow users to edit the range if it is not then it is not possible to paste the value in protected before Un Protect so please check
other wise please upload a sample file with your problem
Thanks
Patnaik
TrowaD
Apr 23, 2013 at 11:22 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Apr 23, 2013 at 11:22 AM
Hi Salwa,
Another thing to consider is that the copied range is bigger then the unprotected range.
But again a sample file is desirable.
Use www.speedyshare.com for that.
Best regards,
Trowa
Another thing to consider is that the copied range is bigger then the unprotected range.
But again a sample file is desirable.
Use www.speedyshare.com for that.
Best regards,
Trowa