cchris_uk
03-23-2009, 07:25 AM
Hi,
I have a Sub Worksheet_Change(ByVal target As Range) subroutine that watches for changes on various columns.
I need a way to stop this subroutine being called if I edit a cell from within another subroutine; is there an easy way to do this?
I tried setting a boolean variable in my subroutine to 'true' and having the Worksheet_change subroutine check if it was 'true' and exiting if it was, but this does not seem to work.
Regards,
Chris
I have a Sub Worksheet_Change(ByVal target As Range) subroutine that watches for changes on various columns.
I need a way to stop this subroutine being called if I edit a cell from within another subroutine; is there an easy way to do this?
I tried setting a boolean variable in my subroutine to 'true' and having the Worksheet_change subroutine check if it was 'true' and exiting if it was, but this does not seem to work.
Regards,
Chris