Error Message- Cannot run the macro

[Clarence Perdue Jr.]

I created a 2007 Spread Sheet with macro. The spread sheet was working on another machine. I save the spread sheet and mail it to another machine. It now does not work and gives an error message Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled. When I open the spread sheet I do not see the macros at all.

 

[Sathish KV]

Hi,

Macros may have been disabled in the system

Try Below

Go to New Excel window -> Alt T + O -> Trust Center -> Trust Center Settings -> Macro Settings -> Enable all macros

 

[Clarence Perdue Jr.]

I saw it was dis able and I enable but it did not bring back the code. This need to be done when you create your excel document.

 

[Luke M]

Looks like you saved you workbook in the XLSX format. XLSX books strip all VB out of them when saving. Hopefully you have a back-up somewhere, where workbook is saved as XLSM (remember, M stands for macro!)