Forum Discussion
FlowTime1990
May 05, 2024Brass Contributor
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.
- peiyezhuBronze ContributorIf possible,upload your Excel file for trouble shooting