Worksheet_Change to prevent area change

[JackDanIce]

Hi,

I have a dynamic area under B14:H14, which I only want to add rows to via macro input and not limit via cell protection.

Is there a way to use Worksheet_Change to detect if a user enters a value in a defined area and prevent cell value edit?

Tried to search for answer, but must typing wrong. Results include recurrsive change event loops and surpressing change events, but yet to find solution for using worksheet_change to to detect and prevent cell edit.

Any suggestions? TIA,
Jack

 

[Michael M]

@Trebor76
I knew there was something wrong with you

I support (Manly Warringah Sea Eagles)

Carn the Storm !!!!!

 

[Trebor76]

I knew there was something wrong with you

"Those who live in glass houses should not throw stones." The Storm??? They're not even a NSW team.

 

[Michael M]

Better than supporting an AFL down here though...

 

[JackDanIce]

As a whinging pom who hates heat, I'm gonna stay out of this.. will wait until it gets to the next Ashes!

 

[Michael M]

@JackDanIce
If you hate the heat.....wait for the ashes ....carn aussies!!!
But back to the problem.....did you last Excel related post create a solution, or are you still looking ??

 

[JackDanIce]

Ha, my bad, sorry forgot to answer I'd found "a" solution.. but now I need to disable Excel features too.

Using this link as a starter: https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.protect

(and Target.ParentName works fine on a Win PC, but not Apple and of course we have mix of users here and has to work on both, next prob to figure out!)