PDA

View Full Version : hiding formulae in excel 2007



philfer
04-21-2010, 03:06 AM
Hello,

Is there a way to hide formulae in a worksheet so the user can only see the calculated value

I know you can hide the formula bar but this is easy for the user to reverse

Thanks
Phil

Ago
04-21-2010, 03:18 AM
Maybe you could hardcode the formulas in a macro and passwordprotect the code?
By using a worksheet_change and just pasting the calculated value in the cell the user wont see the calculation.

markmrw
04-21-2010, 04:39 AM
you could protect the sheet and not allow the user to select the cells