Hello friends

I use excel 2003 and my friends in my workplace uses excel 2007.
Recently I insert a module to use function for conversion of numbers to text.

I enable macros and keep security level low and make changes in trusted publishers to allow Visual basic projects.The module works fine in excel 2003.

When I try to keep the same settings in Excel 2007 , an error message appears and I could not apply the above user defined function in excel 2007.
I have enclosed the screenshot of error message.

I need help and guidance from the experts.

Recommended Answers

Have you checked to see if you are using any depricated features in your function?

Jump to Post

All 2 Replies

Have you checked to see if you are using any depricated features in your function?

the problem is solved by another source.I missed to allow macros and VB module in excel.thanks for interest in my problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.