Forum Discussion
Excel Macros Causing Display Glitches On Workbook with Multiple Pages and Formulas
Hello, I'm hoping someone can help me out here. I have seen a post with similar issues that was resolved, however, I tried the solution (turning on and off screen updating for the macros). The ma...
I find that a manual page-down and page-up usually fixes the display issue. So you could add this:
ActiveWindow.LargeScroll Down:=1
ActiveWindow.LargeScroll Down:=-1
ActiveWindow.LargeScroll Down:=1
ActiveWindow.LargeScroll Down:=-1
Thank you for taking the time to respond! This would work I would imagine as i simply scroll down then up to refresh the page, however, this issue is not something that happens when the page opens up. It only happens when i enter data into a cell. Example: I click the button to open the page i desire, everything looks good, and then i enter data into a cell, everything still looks good, and then when i hit enter or anything else to have the data officially input into that cell that is when the display goes all wonky. so i would need to scroll down and up every time i enter data into any cell on the given page.
- Hmm. Perhaps you should click Help, Feedback and tell them something's wrong. Make sure you include a screenshot of the issue.
- Thanks Jan. Yes, I have reached out to microsoft and the reply is basically that they dont have an answer and that these things happen when using macros.... It seems so strange. I dont want to waste your time too much but If you would like, I could screen share the issue with you to show you or try to describe the issue and send a file
Jn12345 Yeah, as soon as they think macros are involved all thinking appears to stop. Point is, this also happens when no VBA is at play at all. I see this all the time: Delete a few columns from a spreadsheet and the display doesn't change until I page-down and page-up.
