Command Button deactivated

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

Thread: Command Button deactivated

  1. #1
    Board Regular
    Join Date
    May 2006
    Location
    Irving,TX
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Command Button deactivated

     
    Not sure what has happened, I had a malware attack while using Excel, shut everything down, scanned and cleaned computer now my command buttons no longer work in any file.

    SO thinking it must be a setting that has gotten tripped but can't find it.
    Eric Kelcher

  2. #2
    Board Regular scott_n_phnx's Avatar
    Join Date
    Sep 2006
    Location
    Phoenix, AZ
    Posts
    445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Command Button deactivated

    Did you have a macro that turned off events (Application.EnableEvents = False)? It may need to be turned back on with Application.EnableEvents = True.

    Code:
    Sub TurnOnEvents()
    
    Application.EnableEvents = True
    
    End Sub
    Allons-y


    Please remember:

    -Use [ code ] code tags [ / code ] (No spaces). It keeps posts clean, easy-to-read, and maintains VBA formatting.

  3. #3
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Command Button deactivated

    Microsoft MVP - Excel

  4. #4
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    2,047
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Command Button deactivated

    Mmmm, it's probably not malware, but the recent Windows update. There quite a few threads on this forum regarding same.

    Use a cleanup software to clean all temp files (e.g. CCleaner), or
    manually search for *.exd files and delete them.

  5. #5
    Board Regular
    Join Date
    May 2006
    Location
    Irving,TX
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Command Button deactivated

      
    Yeah, I ran both the macro to enable events and deleted the .EXD files from my temp folder, Hopefully I don't have this problem again tomorrow.
    Eric Kelcher

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