Hiding formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Drake - 13 Nov 2007 07:27 GMT

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

Reply to this Message

carlo - 13 Nov 2007 07:56 GMT

> I've finsihed my spreadsheet and I'm able to lock the cells I don't
> want people to mess with.
[quoted text clipped - 5 lines]
>
> 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

Reply to this Message

bc@brianjwc.vispa.com - 13 Nov 2007 08:15 GMT

> I've finsihed my spreadsheet and I'm able to lock the cells I don't
> want people to mess with.
[quoted text clipped - 5 lines]
>
> 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

Reply to this Message

Drake - 13 Nov 2007 08:52 GMT

>> I've finsihed my spreadsheet and I'm able to lock the cells I don't
>> want people to mess with.
[quoted text clipped - 13 lines]
>
>Brian

That solved it. Thanks

Reply to this Message

Sean - 13 Nov 2007 08:19 GMT

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

Reply to this Message

Rate this thread: