How do I hide spreadsheet range from data entry?

D

Deborah_NY

Specifically, I want to restrict from view a specific range on a sheet where
I have someone entering data ... I need them to enter data into rows which
will create sensitive information in cells below (these I want to hide from
all but original creator) ... any ideas??
 
A

aidan.heritage

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.
 
Top