Making changes to worksheet buttons in Excel clears the undo stack

[jackms]

I have some buttons an Excel sheet and and I have VBA code that changes a property of a button based on user actions.
The problem is, once VBA changes the button property, it considers it a worksheet change and clears the Undo stack.
I know there's no way to prevent VBA from clearing the Undo stack when making a change to a sheet, but perhaps I can make the button's parent some object other than the worksheet? Or any other ideas?

 

[cmowla]

Maybe try this?

Application.EnableEvents = False

'(Your code to change the button)

Application.EnableEvents = True

 

[jackms]

Thanks. But that doesn't do the trick. The undo stack still gets cleared.

 

[Fluff]

What sort of button is it & what are you changing?

 

[jackms]

It's actually a Group made up of Buttons and a GroupBox. The Buttons and GroupBox are the ones you get from the "Form Controls" section in Developer -> Insert

I change .Left / .Top / .Title for the Group. A change to any of those clears the undo stack

 

[Fluff]

Thanks for that, unfortunately I don't know of any of moving the buttons without clearing the undo stack.