Hi - The below code will refresh the sheet by unprotecting and then again protecting your file. However, it needs to be called each time you need to run it i.e. this wont refresh the page after each 60 seconds...
Colleagues with more experience in these areas may be able to provide more accurate solution i believe.![]()
Sub Refresh() Application.DisplayAlerts = False Worksheets("Test").Unprotect Password:="abcd" ' Replace with your password ActiveWorkbook.RefreshAll Worksheets("Test").Protect Password:="abcd" ' Replace with your password End Sub
Thanks
Bookmarks