Hello all,
Back at it again trying to learn more and came across something I'm having a hard time figuring out. I have a workbook that protects all the sheets with vba. I'd like to protect a specific worksheet but still allow row height changes on only a specific set of rows (10-1000). I'm not aware of using the Range command with the Protect so I'm at a bit of a lose. Any one have any ideas?
Here's the protect code I'm using right now.
Not a fan of the Allow FormattingRows command because it takes away from the usage I have of being protected. That's the section I want to limit...
Back at it again trying to learn more and came across something I'm having a hard time figuring out. I have a workbook that protects all the sheets with vba. I'd like to protect a specific worksheet but still allow row height changes on only a specific set of rows (10-1000). I'm not aware of using the Range command with the Protect so I'm at a bit of a lose. Any one have any ideas?
Here's the protect code I'm using right now.
Code:
ActiveSheet.Protect Password:="TESTING", AllowInsertingRows:=True, AllowDeletingRows:=True, AllowFormattingCells:=True, AllowFormattingRows:=TrueNot a fan of the Allow FormattingRows command because it takes away from the usage I have of being protected. That's the section I want to limit...
Last edited:
