Insert shape on worksheet to refresh page

[Ozhatch]

I know that I can refresh a worksheet by clicking on the refresh icon in the ribbon, or by pressing F9. What I'd like to do is to create a shape which is easily seen—my eyes ain't as young as they used to be—and activated with cursor and mouse click. Creating the shape is easy; please would someone show me how to write the instruction that goes with it?

Thanks in anticipation.

 

[JumpingCrab]

You can add a shape to the worksheet using Insert>Shapes.
Right-click on the shape and select "Assign Macro..."
Accept the proposed macro name (or change it) and select "New"
In the macro editor add the following code (assuming you created a rectangle):

Sub Rectangle1_Click()
    ActiveSheet.Calculate  
End Sub

You only have to add the middle line. Excel adds the Sub ... End Sub sections.

Clicking the rectangle on the sheet will now calculate the sheet.

Hope this helps.

 

[Ozhatch]

Thank you so much! That's exactly what I needed.

 

[Ozhatch]

Thank you so much! Exactly what I needed!

 

[JumpingCrab]

You're welcome!