(Apologies if this post appears twice: I first posted this a couple of hours
ago but it has not shown up - to me at least - as posted, and I am keen to
get this posted asap. I'm relatively new to this, so apologies if I'm not
following the 'rules' and frustrate people)

I have an Excel model that needs to be distributed to a number of different
people.

When first distributing to colleagues, the model will be completely
unprotected.

I want to give colleagues 2 options for them before they sent it externally,
depending on their decision about who they're sending it to.

First, I want colleagues to have a macro on a separate worksheet that when
run protects all formulae (to simply prevent accidental delete/change,
etc.). I'm after a macro that will do this. Second, I want colleagues to
also have the choice of both protecting and hiding all formulae (as in some
cases they'll not want the next, external recipient to even see the
formulae) and I'm after a macro to do this also. [When they've chosen which
option, they'll then just delete this separate worksheet.]

It's a fairly large model, and I could provide versions that I have manually
either just protected, or protected and hid, formulae. This is a fairly
boring task for me and not very elegant. Is there a relatively
straightforward way of doing this via macros? Or would the macros end up
with a fair amount of script that effectively just replicates what I would
otherwise do myself manually?

If anyone has any thoughts they would be much appreciated. [Out of interest,
is it possible to have macros to reverse these operations?]

For simplicity, let's say I have Sheet 2 and Sheet 3 that contain formulae,
both within the ranges (A1:A10).

Thanks again

Mike