intermittently with my xlsb workbooks, I receive a "Automation error, Invalid forward reference, or reference to compiled type"
I notice it occurs when the code is selecting/activating a tab (worksheet)...if I manually go to that worksheet, then run the rest of the code, it works.
The only way I found to fix this issue is if I use an older archived file (e.g., a file dated 2 days ago) and override the main template. oddly, this kind of thing seems to happen with different files I run on the network drive.
perhaps my excel is just messed up (2016).
I notice it occurs when the code is selecting/activating a tab (worksheet)...if I manually go to that worksheet, then run the rest of the code, it works.
The only way I found to fix this issue is if I use an older archived file (e.g., a file dated 2 days ago) and override the main template. oddly, this kind of thing seems to happen with different files I run on the network drive.
perhaps my excel is just messed up (2016).