Hellow,
I have an excel file with numerous identical sheets which i am using to retrieve a status report from my employees at work.
In those sheets they have specific cells to update and those cells are being updated using a generic function i am calling using Sub Worksheet_Change in each sheet.
recently i have added for each sheet a TFS table via the Team tab etc..
The problem is when I am pressing the refresh button at the Team tab, the generic function of Worksheet_Change is being called, and getting inside a very long loop that will end eventually.
Is there a way to catch the event when the Refresh Button is being pressed, and check it and then exit the sub of worksheet_change, if it is not pressed i would like to function to run.
Thank you very much for your assistance.
I have an excel file with numerous identical sheets which i am using to retrieve a status report from my employees at work.
In those sheets they have specific cells to update and those cells are being updated using a generic function i am calling using Sub Worksheet_Change in each sheet.
recently i have added for each sheet a TFS table via the Team tab etc..
The problem is when I am pressing the refresh button at the Team tab, the generic function of Worksheet_Change is being called, and getting inside a very long loop that will end eventually.
Is there a way to catch the event when the Refresh Button is being pressed, and check it and then exit the sub of worksheet_change, if it is not pressed i would like to function to run.
Thank you very much for your assistance.
