No button action, What did I do wrong?

[LouPapy]

Hi All,

I've recently took several excel statistical workbooks from a german colleague and translated them into English. The workbooks use a lot of command button to navigate between worksheet and excecute different macro. This morning I reopened some of the workbooks to do more translation and I noticed that all button are inactive. I don't know what I did to make that happen, any idea? I'm guessing it must be something within excel it self as even the original workbook I haven't touch are affected (The odd thing is that on one of the workbook, the menu button of one of the 9 sheets are working but not the other).
I did go into the advanced menu of excel option to make sheet tab and gridline visible and I might have change something else by mistake.
I'm using Excel 2007

Thanks

 

[venkat1926]

off the cuff

what is the excel version
have you clicked "enable macros"

close the files and try again;.

 

[LouPapy]

The version is excel 2007, most files saved as macro enabled and macro were enabled in the others...