I have a worksheet macro (worksheet_change) that only works properly once I have closed and reopened my workbook, without running any other macros that the workbook has. Otherwise, I have to select any cell after changing the target cell so it updates.
In details, if I open my workbook and work the other macros it has first, then when I move onto this worksheet and change the target cell which contains a list, my table does not update its values according to the selected value until I just click on any other cell within the worksheet.
However, if I close and reopen the workbook, go straight to that worksheet, and change the target cell, then the results in my table update instantly, without me having to click on any other cell.
The problem is, the workbook is supposed to follow a sequence where I have to run all the other macros before I get to this worksheet with the issue. I have tried to put it to sleep for a few milliseconds prior to calling the worksheet_change macro, but that did not help.
I wonder if anyone has any ideas on how to overcome this issue. Any help is very much appreciated.