Problem with running Macro from Button form control

[dentler]

This is sort of related to an earlier post I made regarding ghost button, where it was decided that it would be better to use the button from control rather than ActiveX button controls. I initially began replacing the ActiveX controls with Button form controls on my ledger sheet and all worked well.
Then I first tried copying several of the buttons to a sheet I call Manager, which contains nothing but buttons for various functions. I was hoping by doing it this way that it would save me some time individually creating the same buttons to do virtually the same job but from a different worksheet. That failed, it would take me to some other place in my code and simply STOP. So I suspected that I could not copy the Button form controls from anther sheet, and created one on the Manager sheet to test. In created the following Macro to run from the button form control"

Please Login or Register  to view this content.

As you can see, it is a very simple procedure to take me to the JanSwitch routine, that basically takes me to the January tab.

What is strange is, that if I click on this new button on the Manager tab to run the above code, it also takes me into my code and then just Stops, but if I go directly to the macro shown above and then click in it and click Run Sub, it works just fine.

Is anyone aware of why this occurs, or if I am overlooking something?

[TMS]

Maybe you need:

Please Login or Register  to view this content.

Pretty sure that when you are running a macro from the VB Editor, ScreenUpdating has no effect.

[dentler]

No change. I do not normally include the true function in my switch code as the other routines that follow I also do not want any screen flashing to occur. In any case, I tried it, but it still does not work, unless I run it directly from within the macro rather than using the button.

[TMS]

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[dentler]

I found the problem, I had inserted another routine to fix a problem that was occurring in another part of the workbook.. I realized that one month switch worked fine while others did not, once I isolated it to the routine and removed it from the switch, everything works fine.

What was happening is that this routine was trying to land the cursor on a locked area of the worksheet. That was throwing the code out of whack.

I still want to thank everyone for their input. I have found the Excel Forum extremely helpful and value everyone's input.

[TMS]

You're welcome.


Glad you sorted it out.