Hi All,
I have a protected worksheet that includes several embedded charts, one of which I enable users to update with the following macro:
Private Sub Rectangle55_Click()
With ActiveSheet
.Calculate
.Unprotect Password:="mypassword"
.ChartObjects("Chart...