Results 1 to 3 of 3

Excel update resulted in VBA Compile error

This is a discussion on Excel update resulted in VBA Compile error within the Excel Questions forums, part of the Question Forums category; I put together a recap for band competitions and used a filter (if 0 it hides the column) to allow ...

  1. #1
    Board Regular
    Join Date
    Jun 2011
    Posts
    128

    Default Excel update resulted in VBA Compile error

    I put together a recap for band competitions and used a filter (if 0 it hides the column) to allow for different number of school entries. Yesterday after an upload of Windows 12/11 updates, the code procedure I named "ChkTogglerows" suddenly caused a Compile error: Method or Data member not found. I was able to do a restore and stopped any Window updates, but this recap is being used by others. Other than rewriting the code is there anything that can be done?

    Any suggestions? Thank you!

  2. #2
    Board Regular
    Join Date
    Sep 2013
    Location
    Blue Mountains, Australia
    Posts
    2,652

    Default Re: Excel update resulted in VBA Compile error

    Try this:

    Office Update breaks ActiveX controls | Excel Matters

    I used this for a colleague at work yesterday, and there are several recent posts on this forum similar to yours, also reporting success.

  3. #3
    Board Regular
    Join Date
    Jun 2011
    Posts
    128

    Default Re: Excel update resulted in VBA Compile error

    Quote Originally Posted by StephenCrump View Post
    Try this:

    Office Update breaks ActiveX controls | Excel Matters

    I used this for a colleague at work yesterday, and there are several recent posts on this forum similar to yours, also reporting success.
    Thank you. The removal of the MSForm.exd file solved the problem.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com