I have a macro-enabled sheet where I perform calculations by unprotecting the sheet and then protecting the sheet post calculations. The sheet has a button "CALCULATE" that triggers calculations.
Scenario:
1. I have performed a calculation and saved the sheet as is.
2 Closed the worksheet and re-opened the same
3. on Clicking "CALCULATE" now it gives error
"Run-time error '1004':
The cell or chart you're trying to change is on a protected sheet.
To make a change, Unprotect the Sheet. You might be requested to enter a password.
Kindly help