Protection + being able see formula

[cidfidou]

Hi all,

I have a created a complex doc with loads of formulas to be used by different people.

Is there a way to protect all the calculation cells while showing the formula in the bartool? Indeed with actual protection we cant read anymore the formula.

Any help would be sweet.

Thanks

 

[Richard Schollar]

Hi

You should be able to see the formulas unless you have set the Hidden property of the cells - check via Format>Cells>Protection tab and ensure that Hidden is unchecked.

 

[VoG]

When you protect the sheet, untick Hidden.

 

[cidfidou]

Wow! that was fast!!!

Thanks a lot. Have a good day