Depending on a couple things, you can try this one. It will change the Format Cells-->Protection option to Hidden, and then Protect the Sheet (No Password). To modify, just click on the Unprotect Sheet under Review.
Another way, if you don't need the formulas to remain, just the result, would be to just copy/paste special. This will keep the result, but discard the formula. The down-side is that you would have to re-apply the formula later if needed. For that, you can just modify the code to this.
Bookmarks