Freeze Shapes in Excel

[meetgilbert]

Hi team

I searched online for this but got no solution, hoping to get one here:


When I scroll then all cells should move but shape should not move.

Any way to do that ?

[Marc L]

Hi,

no as the shapes are linked to their coordinates or you can freeze them at the top of the worksheet if you freeze the pane …

[meetgilbert]

@Marc L: Thanks Marc. I will follow the top technique you suggested.

[Olly]

There's a similar question (with answers) here: https://stackoverflow.com/questions/...ht-in-excelvba