Static Macro Shapes When Scrolling

[ExcelRoy]

Hi,

Would there be a way to stop shapes moving when scrolling

I have 4 rounded rectangles that I use as macro buttons and would like the to sit to the right near the top of the screen when scrolling

Not sure if its even possible

Many thanks for any help

 

[My Aswer Is This]

1.Place your buttons where you want.
2. Click in a cell two rows below the shape
3. From the view menu choose Freeze panes

 

[ExcelRoy]

Hi my Answer,

Many thanks for the reply but I have a freeze pane working at the top of the sheet already with the header details

I have a total of 4 buttons I would like to "Freeze"

Thanks anyway

 

[My Aswer Is This]

I do not see a problem. Put all the buttons near the top of the sheet.

Click on some cell below the buttons and choose Freeze Panes

All the rows above the active cell will be frozen including Row (1) which I assume is where your headers are.
Choose Freeze Panes. Not Freeze Top Row