Buttons on top of other

[RAJESH1960]

Hello Experts
I have this excel sheet which has 2 macro buttons one below the other namely Button1 and Button2. I want to place the buttons one on top of other with the help of a code. When I press Button1 automatically Button2 must be on the top and vice versa. If the user presses the Button1 before Button2 then the code generates an error. To avoid this I want to try the above way.

 

[RAJESH1960]

All you have to do what I suggested and see what happens. I don't know if you want to have a result of toggling codes.
Click on the button and one macro is activated while the text on the button changes to what the next macro will do.
Click again and the next macro will run while it changes the text again for the first macro.

BTW, you don't need to quote whole posts. most of us know what we suggested. All it does is create extra clutter.

I tried but couldn't get the desired result. For the time being, decided to go with 2 buttons. I have created a message box code in the first button saying reminding to press the second button before running the first button.

 

[jolivanes]

What is "desired result"?

 

[RAJESH1960]

What is "desired result"?

I mean expected result. Place the buttons on top of one another and when I press the button, the button on the top should go below and so on...

 

[jolivanes]

That's not what I suggested is all about.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Hide / Unhide Buttons with the help of a code - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[RAJESH1960]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Hide / Unhide Buttons with the help of a code - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Ok. Fluff. In future, I will provide details if shared on other platforms.

 

[RAJESH1960]

Ok. Fluff. In future, I will provide details if shared on other platforms.

The above query has been solved.?