Glitch in VBA Code

[MsJojo]

I have a spreadsheet with a 'main screen' (when the 'department overview' icon is clicked, or basically the spreadsheet start from A1.
When I click on the 'Team Breakdown' icon, it runs the below macro, which technically brings me to around row 100 of the spreadsheet (different part of the spreadsheet). -- This is PERFECT, what I want the button to do.

My problem is that: When the macro runs, it seems like there's a glitch - in which all of the pictures, icons gets 'enlarged' before going back to the original size. (see below 2nd image)

It is a very 'distrubing' view for the user, and I want it to stop. I DON"T WANT the icons to get enlarged, when the macro runs. I just want it to take me to the middle of the spreadsheet.

Is there something I can do, to avoid the 'enlargement of the icons/pics' during the macro run? Thanks.


------------------
Macro for the 'Team Breakdown' icon:

Please Login or Register  to view this content.

------------
images of spreadsheet:
(see attachments)

[dangelor]

Possibly...

Please Login or Register  to view this content.

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

@dangelor: ah, too quick for me. At least we concur in our response.

[TMS]

Before the Moderators say it ...

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional.)

[MsJojo]

Thanks, It works! - I don't see the 'glitch' anymore.

But now, the button doesn't take me to the screen of Row 98 (see 3rd image where the screen shows starting Row98).

[TMS]

Maybe swap these two lines over:

Please Login or Register  to view this content.

Please Login or Register  to view this content.