Hi,
Pardon my faulty English as it is not my native language.
I have a few sheets, where one (sheet 3) has a Worksheet_Change set up which works fine.
However, this change doesn't trigger if I programmatically from (sheet 1) trigger a change to (sheet 3).
I have tried looking online and in the help provided with Excel, but I am non the wiser as to why this change doesn't trigger the code in (sheet 3).
Does VBA not allow for this?
Any information is gratefully accepted.
Pardon my faulty English as it is not my native language.
I have a few sheets, where one (sheet 3) has a Worksheet_Change set up which works fine.
However, this change doesn't trigger if I programmatically from (sheet 1) trigger a change to (sheet 3).
I have tried looking online and in the help provided with Excel, but I am non the wiser as to why this change doesn't trigger the code in (sheet 3).
Does VBA not allow for this?
Any information is gratefully accepted.