Hide Underlying Cell Formulas

[robben5]

Hi All

I have a workbook which I share with my customer. I want to hide all underlying cell formulas in the workbook. Is there any way, macro etc. that I can hide and unhide all the formulas as per my convenience. I do not want to use copy > paste special > values. Any help will be greatly appreciated.

Regards
Robben

[Neil]

Robben,

You don't actually need to hide the formula editing window, choose
Format/Cells/Protection and check the "Hidden"
checkbox, then when you protect the sheet, formulas will be hidden.

Note, though you will need to enter a password for editing (Not necessary
for viewing) but it's not that secure, it doesn't take long to find a program
or macro on the internet to crack the password.

If you want something more secure then you will need to have a combination
of VBA and protected cells, but as with ALL copy protection it's not 100% and
if someone is determined enough they will still get in.

HTH

Neil
www.nwarwick.co.uk

"robben5" wrote:

>
> Hi All
>
> I have a workbook which I share with my customer. I want to hide all
> underlying cell formulas in the workbook. Is there any way, macro etc.
> that I can hide and unhide all the formulas as per my convenience. I do
> not want to use copy > paste special > values. Any help will be greatly
> appreciated.
>
> Regards
> Robben
>
>
> --
> robben5
> ------------------------------------------------------------------------
> robben5's Profile: http://www.excelforum.com/member.php...o&userid=36014
> View this thread: http://www.excelforum.com/showthread...hreadid=572515
>
>