Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I'm trying to protect around 150 cells in Col J Row 12 onwards that do not have a validation setting i.e. they are all 'Allow: any value'.
The problem is they all contain different validation input comments that I need to retain.
I can't simply highlight the column and edit the validation because I get the "Cells contain more than one kind of validation. Do you want to erase and continue?" warning, which I can't say yes to.
Is there a VBA solution to protect the cells in Col J Row 12 onwards that contain the input validation with, say, "allow a whole number equal to" 123456 and preserve the input messages?
Many thanks!
I'm trying to protect around 150 cells in Col J Row 12 onwards that do not have a validation setting i.e. they are all 'Allow: any value'.
The problem is they all contain different validation input comments that I need to retain.
I can't simply highlight the column and edit the validation because I get the "Cells contain more than one kind of validation. Do you want to erase and continue?" warning, which I can't say yes to.
Is there a VBA solution to protect the cells in Col J Row 12 onwards that contain the input validation with, say, "allow a whole number equal to" 123456 and preserve the input messages?
Many thanks!