View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hide Columns and Protect cells v2003

You can protect the worksheet with a password, but this type of protection is
easily broken.

If you have stuff that you don't want others to see, don't put it in excel. If
you have to put it in excel, then don't share the file with others.

Mike wrote:

Hi, I have some confidential info within cells in columns that should not be
viewed by staff. Can you advise the best way I can somehow hide these columns
and not allow staff to simply "Unhide" the columns. Can I password protect
hidden columns?
--
Regards
Mike


--

Dave Peterson