Hello,

After installing excel 2010, i´m not able to open xlsm files or access the VBA coding screen (View code for any excel sheet).

When i open .xlsm files it says:

Excel found unreadable content in 'Schema_2012.xlsm'. Do you want to recover the content of this workbook? If you trust the source of this workbook, click yes.

When i click yes, i get this:

Excel was able to open the file by repairing or removing the unreadable content.

Then i can see the link 'Click to view log file listing repairs':

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error213200_01.xml</logFileName><summary>Errors were detected in file 'N:\Tech Support\Schema\Schema_2012.xlsm'</summary>-<removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart></removedParts></recoveryLog>


If i open new blank excel sheet i noticed that i´m not able to access ''VBA screen / View code screen'.
I did enable both ActiveX and Macros in File -> Options -> Trust center. The change did nothing.

Q1) Does anyone know how the get VBA working in Excel 2010?
Q2) How i can open xlsm files? The answer would probably be to get VBA working first.