<div>
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.<br />
<br />
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?
</div>


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?

<div>
<div class="content wysiwyg-content">
Following an upgrade to 2007 from 2003 , user is unable to run macro. Receives the following error:<br />
Can not run the macro &quot;Name of File &quot;. The macro may not be available in the workbook or all macros may be disabled. <br />
<br />
Does anyone know a setting or plug in to resolve. Or does the user have to downgrade product to 2003 ?<br />
<br />
Thanks,<br />
CJ
</div>
</div>


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

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

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

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