workaround for recent bug where resizing columns changed zoom?

I've noticed this maddening problem lately, searching for it turned this up: \ \ Resize columns in Excel spreadsheet, zoom auto enlarges. Have to manually adjust the zoom back to original. - Microsoft Q&A\ \ which confirms for me that others are having similar issues recently, so it seems like a bug and not my workbook being corrupt. However MS's response does not sound like they recognize it as a widespread problem (ie one worth fixing anytime soon) and they offer generic BS for troubleshooting. Excel has never exhibited this behavior before these recent updates. WTF, Microsoft!\ \ Also it's worse than just the zoom changing - after resizing a column, you can't select any columns on the sheet. The only way to "reset" the worksheet is to click on a different sheet in the workbook and then back which restores the ability to select, but you still have to manually restore the zoom level. Argh!\ \ I tried adding macro code, to hopefully save ActiveWindow.Zoom to a global variable and restore the value later, to various ThisWorkbook events: * Workbook_SheetBeforeDoubleClick * Workbook_SheetSelectionChange * Workbook_WindowResize * etc.

but I'm not finding an event that fires from resizing columns, so am not sure where you might capture the zoom level before it gets wiped or restore after. \ \ But even if the zoom can be preserved, the page view is still hosed - you can't select anything on the sheet until you change sheets then change back. That too could be done in a macro with ScreenUpdating disabled, but we would still need an event that fires when a column is resized.\ \ Has anyone found a way to mitigate this until MS fixes it?