View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M M is offline
external usenet poster
 
Posts: 2
Default Protecting specific cells


Using an excel program at work that works perfectly. However it has
been recently discovered there are certain end users who have been
modifying certain formulas and variables (company commissions
schedule, etc.) that have been stored in certain cells. These cells
are located in A47:DA96. I have set the Row Height (47 to 96) to
zero, however it is still accessible by others. How can I protect
these cells either by setting some password so no one can change the
info in these cells or hide them from view completely?

Thank you in advance.

Mike