IBM transfer file CWBTFXLA no longer works in Excel 2007

This box is XP pro SP3. Newly formatted 30 days ago so there shouldn't be any issues. Last months closing the functionality of this macro worked fine. This month it just makes that dull MS sound but fails to do what its supposed to do. so far I have gone into the add-ins and removed-rebooted the PC and re-did the add-in. Still nothing. I'm not sure what else there is to do or check. One more important pc of info.... the security on the macros keeps changing also if you try to run any macro it is greyed out.

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.

Fraser_AdminAuthor Commented:
Run Office Setup and verify these are included in setup
1.Not sure if this is your issue, but I had a similar problem and found out (after a fairly extensive search) that two settings (Digital Certificate for VBA Projects and Visiual Basic for Applications) from the Installation Options tab had the Not Available option selected when the application was installed.

When these where changed to Run from My Computer the Record Macro (and all other VBA functionality) was OK.

Use MSO2007 Installation **.

2. Make sure the "Visual Basic for Applications" option is installed:

+ Office Shared Features
+ Visual Basic for Applications

3. Enable macros:

Click on: The Office Button | Excel Options | Trust Center | Trust Center Settings (Button on Right) | Macro Settings

Make sure you "Enable all Macros"

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
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
Operating Systems

From novice to tech pro — start learning today.