LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.newusers
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the command to replace a cell's formula with it's value? Cindy Excel Discussion (Misc queries) 8 May 15th 09 07:26 PM
Pivot Table Error Message - "Command Text not set for command obje Jeff Divian Excel Discussion (Misc queries) 0 November 7th 07 10:26 PM
Formula help...right/find command Jambruins Excel Discussion (Misc queries) 5 July 6th 07 10:18 PM
help create a formula using the IF command with AND [email protected] Excel Discussion (Misc queries) 2 January 16th 06 06:29 PM
how do i enter data using formula and the Copy command For exa. 5494 New Users to Excel 0 January 28th 05 05:55 AM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"