Add Button to Refresh all Worksheets

[amazeballs]

Hi,

I have a macro setup that captures all of the sheet names in a workbook, and puts it on a Contents page (sheet 1).

It's working great however it doesn't automatically refresh when a user changes sheet names. I have to ask users to manually press Ctrl+ Alt + F9 each time they open the workbook.

I'm looking to add a "Refresh" button on the first sheet which refreshes all the data for them.

I've inserted the button and entered the below code however it's not refreshing the data. Can anyone assist?

Thank you


Private Sub CommandButton1_Click()
ActiveWorkbook.RefreshAll
MsgBox "Sheet Names have been refreshed!"
End Sub

 

[sparky2205]

Hi,
why not just call your first macro from the button click?

 

[amazeballs]

Hi,
why not just call your first macro from the button click?

Thanks for your response. I would but I don't know how!

 

[sparky2205]

Right click the button, click Assign Macro and select your refresh macro.

 

[sparky2205]

The above instruction works for a shape.
Just insert a simple shape, like a rectangle, and assign the macro to it as above.