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:
Sub LSSBTotalExtend()
'
'
' Pictures Settings
ActiveSheet.Pictures.Select
Selection.Placement = xlMoveAndSize
' LSSBTotalExtend Macro
ActiveWindow.FreezePanes = True
Rows("90:233").Select
Selection.EntireRow.Hidden = False
Range("A125").Select
End Sub
------------
images of spreadsheet:
(see attachments)
Bookmarks