Disply Bug when calculating

NicolasG

New Member
Joined
Feb 28, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello all, this is my first post here. I get many answers on the site and I find very useful. Lots of bright people here !

I have an excel sheet with multiple macros in it and drop downs menus and toggle button that work fine. However, I get the often recurring problem that I found is triggered either when: a) a changed item in a drop down menu or b) when a toggle button is pressed then bits and pieces from another sheet is displayed on my current sheet. If I go on another sheet and come back, the original screen returns to normal....as if its some sort of refresh display that is not functioning correctly.

Most of my macros start with the sub routine:
Application.Calculation = xlManual
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
Application.ErrorCheckingOptions.BackgroundChecking = False

And end with the subroutine:
Application.Calculation = xlAutomatic
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.AskToUpdateLinks = True

Results are perfectly fine, it's just very annoying for the user...

Anyhelp is greatly appreciated !


Bug shown in picture: see the 5 lines above "RISK MODEL" are from.... another sheet !!!
 

Attachments

  • bug.jpg
    bug.jpg
    81.1 KB · Views: 18

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,214,974
Messages
6,122,536
Members
449,088
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top