Command Button Turned Into An Image???

[kstrait]

This is a very unique and interesting problem that I have never seen before. I had a workbook with multiple sheets. I have command buttons on each sheet that are used to run various macros that I've written. All of a sudden, the button's are no longer clickable. When I try to access their properties, they are treated as images and no longer recognized as buttons by excel.

Has anyone ever seen this before? Every button on every sheet is no longer working. I can create a new command button and it works just fine but the existing ones are useless.

Thanks in advance for your help.

 

[iggydarsa]

Make sure that on your "Control Toolbox" Design Mode is NOT selected.

 

[zaonpt]

Make sure that on your "Control Toolbox" Design Mode is NOT selected.

You clearly didn't read the entire post.

This happened to me also. I haven't figure out yet.

Anyone else got an idea about this issue?

If i find out ill post here.

 

[Big Wade]

Does one of your macros leave multiple sheets selected? This has been known to cause an issue.
And zaonpt, iggy has a valid answer as his entire post didn't mention whether he was in design mode or not.

 

[zaonpt]

Does one of your macros leave multiple sheets selected? This has been known to cause an issue.
And zaonpt, iggy has a valid answer as his entire post didn't mention whether he was in design mode or not.

he said ".. they are treated as images ..." with design mode on this doesnt happen, u click and go to the code, not to image properties.

as for sheet selection, no i dont select sheets.

 

[shiftdelete]

This sounds like the Windows Update issue... Try closing all Office programs, then doing a search on your computer for *.EXD files (not .exe).. Delete all of them (you may need to include hidden files & folders). Then try again, the activeX buttons should now work.

 

[JerBearG]

This totally helped! Thanks so much. That darn .EXD file was the culprit.

 

[jtakw]

FYI, I do believe it's the temp file(s) created by the latest windows updates causing the problem.
For those who may not know how to manually find the *.exd file and delete it, you can just run your system cleaning program and let it do it's thing.
I use CCleaner, but basically, any similar program should do the job, but not sure about the native windows Disk Cleanup.

 

[Aescoral]

I'm quite sure I didn't get any windows/office update, between getting various error with button ActiveX. Does sb have another reason for this error then update?

 

[PeteWright]

Hello and sorry for waking up the sleeper.

For some reason all my ActiveX Command Buttons saved in an Macro-enabled Excel file (*.xlsm) turned into images.

I tried all of the above and more:

1. closed all Office apps
2. deleted all *.exd files
3. made a drive cleanup with the internal tool including system files
4. cleared the Windows TEMP and User AppData\Local folders
5. restarted the computer

Same old, same old.

Is there anything else I can try?
I have MSO365 annual subscription, is there a customer chat that could assist me?

Any help appreciated.