Undo Not Working

[anwilson]

I've been working on this spreadsheet for a while now, and I'm not sure what I put in the code to make it stop working because it was working fine until today.

I went to the Registry Editor and made an UndoHistory entry and it will undo an entry if I have a cell selected and want to undo the text in that cell, but if I want to undo anything else it won't work. Any ideas??

 

[RoryA]

What does your code do? If it alters the workbook, it may clear the undo stack.

 

[anwilson]

It's rather lengthy so if it helps by posting it I can, but I've got one sheet with a bunch of inputs the user will choose from and the second sheet has info that filters based on what the user inputs on the first sheet. It's really just a lot of if-then statements and some advanced/auto filtering in there.

 

[RoryA]

Applying a filter in code would clear the undo stack.