View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Hide Cell Contents.

Select all the cells that you want to hide, FormatCellsProtection and tick
the Hide box.

Then you need to protect the worksheet, ToolsProtection, and either set a
password or not depending upon how secure you want it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dan" wrote in message
...
How can I hide cell contents from being viewed at "Formula Bar" and from
the
rest of users? Appreciate any help.

Dan.