Excel shapes flicker when Screen Updating turned back on

Hello fellow Excel enthusiasts,

I have a small problem I've been trying to figure out for several days and can't seem to find a solution. I'm hoping someone here has come across this issue and can provide some guidance. The issue I am having is as follows. I have an Excel userform with a listbox that simply switches from the current sheet to another sheet then switches back. The problem is the shapes on the current page flicker at the end of this code. I turned off screen updating at the very beginning and turned it back on at the end of this short code so I don't understand why this is happening. Does this happen to anyone else? Is there a solution for this or am I stuck with it? Below is a copy of the code, any help is appreciated.

Private Sub ListBox1_Click()
Application.ScreenUpdating = False

Sheets("Full scope Summary").Select
Sheets("Summary").Select
Application.ScreenUpdating = True
End Sub

have you tried manipulating the code to run under different lines? eliminated some? added others? more than likely, the screen updating has nothing to do with it. that is meant to reflect changes that connected to the screen itself. thus, the name of the method.

my guess is that it's a simple glitch in excel. after all, office products are not the best in the world. have you done any searches like this one?

https://www.google.com/search?q=exce...lecting+sheets

vba_php, Thanks for your help but there's really not much I can change in the code. It is as basic as it gets but for some reason the shapes I am using as "buttons" flickers when screen updating is turned back on. I tried running the search you suggested but couldn't find anything.

what about this search?

https://www.google.com/search?q=exce...ing+flickering

there aren't too many answers with regarding weird things that happen with software. the world is so stupidly complex, thanks to corporations of the world, that really ANYTHING is possible. and they don't even care, nor have they for quite some time. they are OK people, they simply do not have the TIME to care. they do their best. but the truth of the matter is, that, more than likely there is no answer to your issue.

I still couldn't find a solution but will continue searching for one. Thankfully, the rest of my code works fine but having it flicker at the end is less than ideal. In any case, thanks for your input.

Great question Rory, The code I provided is just an incredibly streamlined version of the actual code which switches sheets, performs an advanced filter and returns to the original sheet with the data. The code works fine except for the flicker at the end when screen updating redraws the shapes I have on the sheet with macros assigned. While troubleshooting the problem I realized it happens only when I switch sheets.

Oh man! I didn't realize I could get it done without switching sheets. Thanks for your feedback. Even though the code was working you made me rethink it slightly and I got it working without switching sheets.