Excel update resulted in VBA Compile error

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel update resulted in VBA Compile error

  1. #1
    Board Regular
    Join Date
    Jun 2011
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,908
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    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
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

User Tag List

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