View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How do I hide spreadsheet range from data entry?

Set the height to zero, protect the worksheet - or put the output data
onto a hidden worksheet - OR have the sensitive data on another
workbook entirely which REFERENCES the input data.