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
sullym6Asked:
Who is Participating?
 
sullym6Connect With a Mentor Author Commented:
Just figured it out, it was because I have the conditional sum wizard add-in. Once I removed this all working fine.

Thanks for your help, not sure if I am allowed but can I split the points between all 3 who replied.
0
 
JeewsCommented:
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
0
 
Rory ArchibaldCommented:
Have you set VBA to install on first us? Can you record or run a macro at all?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
sullym6Author Commented:
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

0
 
JeewsCommented:
possibly add the folder where you have your files to the trusted folders for macros in the trust center.
0
 
tilsantCommented:
try this
Excel options>> Trust center>> Trust center settings>>Macro Settings
and Tick as in the image attached.

tils.
untitled.JPG
0
 
sullym6Author Commented:
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.
0
 
sullym6Author Commented:
tilsant that is exactly how I have it setup for macro security.
0
 
Rory ArchibaldCommented:
What happens if you press Alt+f11 in Excel?
0
 
sullym6Author Commented:
nothing apart from a little beep
0
 
Patrick MatthewsCommented:
You can click "Accept Multiple SOlutions" to split the points, but since you answered it yourself, you should just select your own comment :)
0
All Courses

From novice to tech pro — start learning today.