Hi all,
I'm trying to use worksheet triggers to run a macro but it only works one time and then never again. Example: If write a worksheet trigger to hide rows if a cell displays 'Yes' (list data validation), it will work the first time after the workbook was open. After it has worked that one time, it will not work again.
I've checked on google and saw this is a normal thing but there are videos of it working perfectly.
Is there something that needs to be reset in my settings? or code? Please let me know.
I'm trying to use worksheet triggers to run a macro but it only works one time and then never again. Example: If write a worksheet trigger to hide rows if a cell displays 'Yes' (list data validation), it will work the first time after the workbook was open. After it has worked that one time, it will not work again.
I've checked on google and saw this is a normal thing but there are videos of it working perfectly.
Is there something that needs to be reset in my settings? or code? Please let me know.
