Member Avatar for Vimal Bhatt

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.

ERROR.jpg 13.86 KB
  • 2 Contributors
  • 2 Replies
  • 163 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by Vimal Bhatt
Member Avatar for Begginnerdev

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

Member Avatar for Vimal Bhatt

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.