Cannot copy Excel/VBA file to new folder & run

[thoss1]

I had an existing Excel file. I need a new Sub. I copied the existing Excel into a folder I placed on my desktop. I added the new Sub and tested, it works fine. I saved and made backup copies. I then copied the file from the desktop folder back into the orignal folder. When I try to run out of the original folder I get a "Cannot run the Macro...... The macro may not be available in this workbook or all macros may be disabled." The macro is available in the workbook I copied to the original folder. All macros are enabled. What am I doing wrong?

 

[pedie]

I had an existing Excel file. I need a new Sub. I copied the existing Excel into a folder I placed on my desktop. I added the new Sub and tested, it works fine. I saved and made backup copies. I then copied the file from the desktop folder back into the orignal folder. When I try to run out of the original folder I get a "Cannot run the Macro...... The macro may not be available in this workbook or all macros may be disabled." The macro is available in the workbook I copied to the original folder. All macros are enabled. What am I doing wrong?

Please close all the excel workbooks you've open completely and open it again....make sure the macro is enabled...

All the best

 

[thoss1]

Closed all open workbooks and tried again. Got same error. How do I make sure the Macro is enabled? When I go to File > Options > Trust Center > Trust Center Settings > Macro Settings the Enable all macros radial is selected. Do I have to do something else to enable the one new Sub I added. I have other macros that were already in the workbook that access a DB and extract different information. These work from either the folder on my desktop or from the original folder.

 

[pedie]

Closed all open workbooks and tried again. Got same error. How do I make sure the Macro is enabled? When I go to File > Options > Trust Center > Trust Center Settings > Macro Settings the Enable all macros radial is selected. Do I have to do something else to enable the one new Sub I added. I have other macros that were already in the workbook that access a DB and extract different information. These work from either the folder on my desktop or from the original folder.

Alright, the macro is enabled that way....
Can i see your code? no thats not required....
is the workbook saved as macro enabled like xlsm, xls...etc?
Is this in SharedDrive?