Cannot run the Macro. The macro may not be available in this workbook or all macros may be disabled

Brass Contributor

This is so bizarre, getting an error indicating that the macro is not available.

 

Here is my error message:

FlowTime1990_0-1714925923755.png

The macro I want to run is ZipAllSubfoldersinFolder.  All of the other macros work except this macro and just one other one.  The rest connect to the buttons just fine.

FlowTime1990_1-1714925951774.png

When I assign a button to this Zip macro it gives me this error...

FlowTime1990_2-1714925996798.png

 

 

But look the code is in the file name...how is it not in there or how can it not locate it and run it through this macro?

 

FlowTime1990_3-1714926064579.png

Can someone please help me with this or offer suggestions? I tried changing the macro name...I tried compiling it...I tried changing the code..nothing...I have to pass this on to a team member and I dont want them in the code editor to run this...please help.

 

Thank you kindly.

1 Reply
If possible,upload your Excel file for trouble shooting