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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.