The Mudcat Café TM
Thread #159221   Message #3789555
Posted By: Mr Red
10-May-16 - 09:00 AM
Thread Name: Tech: Interesting stuff (issues) about Windows 10
Subject: Tech: Possible Micr$oft Office update issue
Just spotted a problem with my webpages, sorted now. I generate HTML in VBA from a spreadsheet.

The diagnosis was a change in the behaviour of Excel (who knows what else) and the solution was to include re-calculates (aka F9) at strategic points in my software.

Because macros can flip between pages and spreadsheets you would see a lot of flashing which even for non-epileptics is disconcerting so I switch off window refresh. This has sufficed for 15 years until about a day ago. Maybe the second round of updates today has put the function back to what it was. Who knows? I sorted the problem before Micro$oft so my solution stays where it is!

The message is - if things start becoming odd - hit F9.