

Might de-try freezing to see if this will avoid it. I do use freeze panes but both buttons are well inside the first row, and I have frozen the first 2 rows. Really frustrating, especiallyĪs the before_close macro then seems to take minutes to run rather than the few seconds it normally does. Can't pin anything different I do that might cause it. For the past year or more since it'sīeen happening, I find the workbook can behave for a week or more then really start to play up by flashing the buttons for a few days, then revert to no flashing. To autosize the row for the cell that was changed, as it doesn't seem to do it on the 1st change (the value that changes is in another cell in same row as a result of the c ell I change).Īs time permits, I'll experiment in this area by de-activating them & see if the problem lessens as well as maybe what other situations cause it to happen. The buttons flash, even just because I hit Ctrl-P or Print Preview (but not every time just to be more confusing)! I suspect it has become worse recently since I added _Change events on two worksheets - I force Excel
