Help with Run-time error '438': Object doesn't support this property or method ( Excel 2010/Win 8 )

Question

The following VBA codes worked well two weeks ago with Excel 2010 (Windows 8, Windows XP),  but they only work on Windows XP right now. When using Excel 2010 ( Windows 8 ) I receive a run-time error '438': Object doesn't support this property or method. The error shows up on bold line,

Sub Workbook_open()

......

Worksheets("cover").Activate

Worksheets("cover").Label_exit.Visible = False

......

End sub

Any help will be greatly appreciated.

Sm203

Answer 1

I would think if you deleted the .exd files in XP, then the workbook would work in XP but it would be cumbersome moving back and forth to newer versions (where the faulty update had been applied) where the fix would need to be performed again.  Untested, but that is the impression I get from the information I have seen on this problem.  

--

Regards,

Tom Oiglvy

Answer 2

Microsoft released a faulty update in December 2014 that stopped all ActiveX controls from working.

See https://support.microsoft.com/kb/3025036/en-us - there is a Microsoft Fix it that may correct this (but then the workbook probably won't work on XP any more)