tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
As I create the sheet I'm on a macro decides if each cell should be protected or locked within the range of AS21:AU297 ,now i want to copy the each cells property to Range BA21:BC297
however i have very different formatting and conditional formats and even values in these cells that i don't want to lose,
so is there a way i can copy over just the "Protection" status for each cell? i.e Locked or Unlocked??
please help if you can
Thanks
Tony
As I create the sheet I'm on a macro decides if each cell should be protected or locked within the range of AS21:AU297 ,now i want to copy the each cells property to Range BA21:BC297
however i have very different formatting and conditional formats and even values in these cells that i don't want to lose,
so is there a way i can copy over just the "Protection" status for each cell? i.e Locked or Unlocked??
please help if you can
Thanks
Tony