View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Beeyen Beeyen is offline
external usenet poster
 
Posts: 2
Default Command Bar (formula bar)

Thank You!

"Per Jessen" wrote:

Hi

To hide cell information, ie formulas select the cell, goto Format Cells
Protection Mark "Locked" and "Hidden" Ok

Then goto Tools Protection Protect Sheet Password Ok

Regards,
Per

"Beeyen" skrev i meddelelsen
...
I have a shared workbook located on the network; the workbook has six
worksheets which have to be filled in with information by various people.
I
have been requested to hide cell information from each of the worksheets.
I
used the ;;; method to hide the cell of information in the worksheets,
which
is time consuming but is required. The only problem is I could not hide
the
formula bar option that would allow a user the view the hidden cell
information.

The question I have is; how can I hide the formula bar to prevent one from
viewing the cell information for this workbook only.

Thank you for any assistance you all can offer