caCan not run the macro "Name of File ". The macro may not be available in the workbook or all macros may be disabled.

Following an upgrade to 2007 from 2003 , user is unable to run macro. Receives the following error:
Can not run the macro "Name of File ". The macro may not be available in the workbook or all macros may be disabled.

Does anyone know a setting or plug in to resolve. Or does the user have to downgrade product to 2003 ?

Thanks,
CJ
cjslingAsked:
Who is Participating?
 
TracyConnect With a Mentor VBA DeveloperCommented:
Make sure the workbook is macro enabled, and that you enable the content.  Take a look here:

http://grok.lsu.edu/Article.aspx?articleId=6144
0
 
BullmanTechCommented:
I'm assuming that there are several macros that the user used in 2003 that are being tried and failing in 2007. If that's the case, could you try isolating each of the macros and seeing which work and which don't? Try creating a new macro, save, close and reopen the file, and then running the new macro to see if it's a security issue, where enabling macros is necessary, etc. That will narrow things down.

Also, are these macros in the Peronal Workbook that exists in all open Excel Workbooks or are they in a specific workbook in a Module, ThisWorkbook, or individual sheet code?
0
All Courses

From novice to tech pro — start learning today.