I have a code module that sequentially opens around 40 files so that I can verify the data in the files has been properly updated before I send the files out via email. Initially when I created this code module, I simply used code breaks to pause execution at three different points. I recently decided to use MsgBox as a means of pausing the code.
The issue is that after adding the MsgBox stops, when viewing the worksheet that has 2 charts, the charts no longer display properly. All I see is a placeholder indicating the charts exist. See attached photos.
Any idea why this may be happening?
PS. I tried adding a 2 second pause using 'waittime' to see if that would help but it doesn't.
All personally identifiable data has been blacked out.
The issue is that after adding the MsgBox stops, when viewing the worksheet that has 2 charts, the charts no longer display properly. All I see is a placeholder indicating the charts exist. See attached photos.
Any idea why this may be happening?
PS. I tried adding a 2 second pause using 'waittime' to see if that would help but it doesn't.
All personally identifiable data has been blacked out.