Reply With QuoteDid 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
Thanks: 0
Likes: 0
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
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.
Microsoft MVP - Excel
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.
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
Like this thread? Share it with others