I was hoping to get your help. I want to create a macro that would allow me to copy and/or move a full row dynamically and paste it in another row in a protected sheet (including both locked and unlocked cells). Any thoughts on how I can do this in excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy rows in protected sheet
- Thread starter wizmaster
- Start date
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,835
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
You will need to provide Source sheet and destination sheet information.
The criteria for copying the row in question
AND
the protected sheet would need to be unprotected. Can be doen with VBA if you have the password.
The criteria for copying the row in question
AND
the protected sheet would need to be unprotected. Can be doen with VBA if you have the password.
Upvote
0
Similar threads
- Question
- Question
