View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toshiba
 
Posts: n/a
Default Protecting a worksheet with filters

I have a worksheet with multiple columns and rows that contain sensitive
data. I need this data to develop a price sheet but do not want everyone to
see this data. I use the filters to make my list more viewable and hide a
bunch of columns that are for my eyes only. The problem is anyone can still
unhide the columns after I protect the worksheet. I haven't been able to
figure out how to show just what I want and not have the other info
accessable. Appreciate your help.
--
Toshiba