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
    1 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
    1 Thread(s)

    Default Re: Command Button deactivated

    Microsoft MVP - Excel

  4. #4
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    3,490
    Post Thanks / Like
    Mentioned
    14 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

Some videos you may like

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
  •