Unprotect, refresh, protect again

D

Deeds

I am having big problems trying to unprotect a sheet, refresh all data, then protect again. Here is the simple macro...why does this not get in and refresh before it gets protected again. Please advise what lines I need to add to this to do what I want.

ActiveSheet.Unprotect
ActiveWorkbook.RefreshAll
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
 
Top