Object Error when excel is opened as ".mht" (single web page)

[atf32]

I have a workbook (excel) that is being saved as a single File Web Page (.mht). All of the code/functions and procedures works as expected, except that I have a piece of code that initiates on open and it resizes and initalizes a listbox. When I open the file as an excel file (2003 or 2007), I do not get this error. The error message tells me "Unable to get the OLEObjects proprty of the Worksheet class."..........Does this mean that I need to set a setting for this to work?

 

[atf32]

I have a workbook (excel) that is being saved as a single File Web Page (.mht). All of the code/functions and procedures works as expected, except that I have a piece of code that initiates on open and it resizes and initalizes a listbox. When I open the file as an excel file (2003 or 2007), I do not get this error. The error message tells me "Unable to get the OLEObjects proprty of the Worksheet class."..........Does this mean that I need to set a setting for this to work?

ADDED NOTE: This issue only happens when initiate through the "Workbook_Open" when I initially open the file. If I manual execute the "Workbook_Open" throughthe VBE, everything runs as expected.