Hiding formulas

[Drake]

I've finsihed my spreadsheet and I'm able to lock the cells I don't
want people to mess with.

How do I hide the formulas?

Also, my workbook has more than one sheet. Can I hide formulas in one
sheet, but not the other, etc.? The same would go for locking cells.

Thanks

 

[carlo]

I've finsihed my spreadsheet and I'm able to lock the cells I don't
want people to mess with.

How do I hide the formulas?

Also, my workbook has more than one sheet. Can I hide formulas in one
sheet, but not the other, etc.? The same would go for locking cells.

Thanks

You can lock every worksheet on it's own.
There you can give a password and choose the option
that the user cannot select locked cells.

Maybe that helps.

Carlo

 

[bc]

I've finsihed my spreadsheet and I'm able to lock the cells I don't
want people to mess with.

How do I hide the formulas?

Also, my workbook has more than one sheet. Can I hide formulas in one
sheet, but not the other, etc.? The same would go for locking cells.

Thanks

Hi,
Format the cells with the formulae in :

Format>Cells>Protection> check "Hidden".
The formula will be hidden after you protect the sheet.

Brian

 

[Sean]

Drake, place this in This Workbook, this will remove the formula bar
which shows the cell content formula. The before Close bit will mean
that other files when opened will see the bar, and hence have no
effect on other user files

HTH

Private Sub Workbook_Open()
Application.DisplayFormulaBar = False

End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFormulaBar = True

End Sub

 

[Drake]

Hi,
Format the cells with the formulae in :

Format>Cells>Protection> check "Hidden".
The formula will be hidden after you protect the sheet.

Brian

That solved it. Thanks