This workbook has lost its VBA project, ActiveX controls and any other programmability-related features

[BigJohn67]

Hi. This is my first post.

Excel 2010. Spreadsheet with VBA was written in an older version of Excel (2003, I think). On my machine, the spreadsheet works fine. I'm on Windows 7. On a Vista machine, when we open the spreadsheet we get the subject error. I have Googled, and checked that VBA is installed using Office Shared Features. It is. So is the digital Certificate for VBA Projects.

But most of the buttons on the Developer Tab are greyed out. The Visual Basic and the Macros buttons are not available. But Macro Security is, and when I change macro security, it makes no difference. In the macro Settings window, I have "Disable all macro with notification" selected and "Trust access to the VBA project object model" selected.

I've tried to replicate the settings I have in Excel on my W7 machine on to the Vista Excel machine, but it makes no difference.

I've seen posts talking about Default Security policy disabling VBA, but we don't use Group Policy much, and certainly not to control Excel. I've checked on the Vista Machine's Local Security Policy window but I can't find anything relevant in there.

Finally, I've tried several xlsm spreadsheets on the Vista machine and all of them have the same problem, so its not the actual spreadsheet that is the issue.

Please can anyone advise? Is there a checklist I can work through? I've read http://support.microsoft.com/kb/282847

Any pointers or guidance would be appreciated.

Many Thanks

John

 

[Andrew Poulsom]

It sounds like VBA isn't installed. See if this helps:

http://www.asap-utilities.com/faq-questions-answers-detail.php?m=145

 

[BigJohn67]

Hi Andrew, Thanks for taking the time to reply. I've seen that post you mentioned earlier in my fault finding and googling. But VBA is definitely installed on the Vista machine.
Thanks
John

 

[Andrew Poulsom]

How do you know that? Can you write and run a macro in the Visual Basic Editor? It wouldn't do any harm to install it anyway.

 

[BigJohn67]

Hi Andrew. when I say its installed, it is showing "run from my computer" on the Office 2010 installer under Office Shared Features. But within Excel, on the developer tab of the ribbon, the Visual Basic button is greyed out, as is the "Record Macro" button, so I can't create a macro.
John