asked on

this workbook has lost its vba project but vba is installed

I get this workbook has lost its vba project error when trying to open a excel file that links to Sage. This file works on all machine except one and I have tracked it down to vba not working.
I have ensured vba is installed but it still doesn't work. If I open a blank sheet and go to the developer tab Visual basic and macro buttons are greyed out.
I have done a fresh install but can't figure out why vba is disabled.

Thanks

Jeews

Check the Macro security settings in the machine.

If you let us know the excel version you are using we can give you directions to enable macros

Rory Archibald

Have you set VBA to install on first us? Can you record or run a macro at all?

sullym6

ASKER

It is excel 2007, macro security is set to enable all macros. It was a full install of office 2007 so Visual basic for applications is set to run from my pc

Jeews

possibly add the folder where you have your files to the trusted folders for macros in the trust center.

tilsant

try this
Excel options>> Trust center>> Trust center settings>>Macro Settings
and Tick as in the image attached.

tils.
untitled.JPG

sullym6

ASKER

That does not help, I don't have options for Visual basic or macros in a new document. I am thinking it may be down to some unregistered components but I don't know which ones.

sullym6

ASKER

tilsant that is exactly how I have it setup for macro security.

Rory Archibald

What happens if you press Alt+f11 in Excel?

sullym6

ASKER

nothing apart from a little beep

ASKER CERTIFIED SOLUTION

sullym6

membership

This solution is only available to members.