I have been using this resize function for over a year and it worked perfectly until recently.
Now it's returning a run time error '91 but only when it's called from Workbook_Open event.
When I call it with a command button or manually in debug mode it works fine.
And when it fails, I can see that the addIn has been set but not the automationObject (="nothing")
I'm using Excel 2016 with Office 365 suite and Datalink 2014 version.
Any help would be much appreciated.