Forum Discussion

FlowTime1990's avatar
FlowTime1990
Brass Contributor
May 05, 2024

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

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

 

Here is my error message:

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.

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

 

 

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?

 

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.

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    If possible,upload your Excel file for trouble shooting

Resources