I don't mean it in the syntax way but conceptually can
worksheet_change be in public scope?
Instead of copying and pasting the same code for each sheet vba
coding, I was wondering if there's way to put worksheet_change in
thisworkbook and call the function from each sheet.

TIA,
Daniel