Enabling/Disabling a Series of Macros Buttons

I have a spreadsheet with a series of distinct macro buttons. It is essential that each button is used only once and in sequential order.

Is it possible to have the first enabled, then once it is used, disabling it and enabling only the next in the sequence and so forth until the buttons are exhausted?

Thank you to anyone who can help.

Not sure I know what you mean, can you give a non-VB walkthrough or example?

I hate do try to explain what someone else is thinking ... but, I'll try anyway.

I think what mrice is suggesting is that you can have only one button. You can change the text on that one button, change what macro it runs (and even move it, so that it appears to be a "different" button). That is way to ensure that someone does not click button 2 before they click button1.

Another way is to keep the multiple buttons you already have, but make them invisible until the appropriate time.

Another way is to keep the multiple buttons you already have, but do not attach them to a macro until the previous button is clicked.

By the way, how did you create your buttons? I know of at least 3 different ways, and the details of how you handle them (and how they appear to users) is quite different.

Even as I was typing this, a 4th way came to mind. So, we will probably need to know more about the specifics in your case to be able to give specific recommendations.