ActiveX control button not working in 2007 after reopening file

[sjagdhan]

Hello everyone,

Just recently I have encountered a bug in MS excel 2007, and need an expert opinion and solution for the same. On of my colleague created a file in MS Excel 2013 and he used ActiveX Control button to automate task. After sharing that file with me, I tried to open it in MS excel 2007.
But to my surprise, it prompted me " Excel found unreadable content in ' <Filename>.xlsm'. Do you want to recover the contents of this workbook? If you trust this source of this workbook, click yes."

After clicking yes, it opened the file with following message:
/*
Removed Part: /xl/comments1.xml part with XML error. (Comments) Load error. Line 2, column 204.
Removed Part: /xl/comments2.xml part with XML error. (Comments) Load error. Line 2, column 235.
Removed Part: /xl/comments3.xml part with XML error. (Comments) Load error. Line 2, column 234.
*/
and after that, the ActiveX control button was not working.

To test that, I created a new test file, and inserted ActiveX control button in new excel sheet. It worked!. But when I closed that file and reopened it, It was not working.

I tried to look for a solution on internet, and tried many things to resolve. like checked for macro settings, ActiveX setting, delete .exd file in temp folder, updated windows... but nothing worked.

Second bug which I found was, When I inserted a ActiveX control button in excel 2007 sheet, it had a label of "CommandButton21" instead of "CommandButton1".

Kindly look into this matter. I am sharing test excel file.

(Note: this file would work in excel 2013. But not in excel 2007)

[davesexcel]

http://www.excelforum.com/excel-prog...t-working.html

[sjagdhan]

Hi Dave,

I deleted all the .exd file as i mentioned, and I even deleted all the temp folders files like you said in previous thread. But still the issue persist.
( Note: I work on shared network computer )

I am now downloading the The 2007 Microsoft Office Suite Service Pack 3 (SP3) and patch file. Hope this will work.

[sjagdhan]

Hi dave,

I installed the 2007 Microsoft Office Suite Service Pack 3 from https://support.microsoft.com/en-us/kb/949585 and now everything is working smoothly.

Thanks for taking time and sharing that thread.

Regards,
sjagdhan