View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] links_now@hotmail.com is offline
external usenet poster
 
Posts: 13
Default Excel Protection Help

I am working on a price sheet some of the columns containing multipliers so I
hide them therefore my employees cannot see specific data. I protect the
worksheet and sent it out but they were still able to unhide the columns and
see the protected data. If I copy and €śpaste special€ť only the values I lose
all my formatted cells, it puts it back into plain text. Is there a way
around this, or a different way? Thanks