Share via

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

Anonymous
2015-01-06T17:51:39+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2015-01-06T20:32:36+00:00

    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

    Was this answer helpful?

    0 comments No comments
  2. HansV 462.6K Reputation points
    2015-01-06T19:43:04+00:00

    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)

    Was this answer helpful?

    0 comments No comments