Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option

Hello Everyone,

My issue is pretty much stated in the title of this thread. When I run a macro through a Form Controls button, it skips part of the process. However, when I rerun that same macro by going to the Developer tab in the ribbon and then choosing the macro from the Macros button, it works fine.

Has anyone ever had this issue, or does anyone know what might cause it?

In case it helps, here is the code:

Please Login or Register  to view this content.

Thanks!

Thanks for the suggestions. Taking out the remove error didn't seem to give an answer and changing the code up gave me a run-time error.

I guess my issue is, is it really the code? If it works completely fine by running it through the Developer tab, how can code be an issue?

Thanks again.

Okay, attached is a test workbook. To begin, there are 2 tabs - "Instructions" and "AB - CDE". When you click on button 4 on the instructions tab the macro will run and it will spit out 2 sheets named "Sheet##" and "Sheet##" along with 7 sheets that are labeled Monday through Friday. Now if you run the macro via the Developer tab, your results will be a tabs named "January", "February", and then the Monday through Friday tabs.

Code stays the same, data stays the same. Macro is just run 2 different ways that should produce the same result.

ButtonIssueMacro.xlsm

Norie - That worked great! Thank you very much! Do you have any idea why that code worked instead of what I had? All in all, it pretty much looks like the same stuff, only switched around a little...

Thanks again!