ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I hide spreadsheet range from data entry? (https://www.excelbanter.com/excel-worksheet-functions/89902-how-do-i-hide-spreadsheet-range-data-entry.html)

Deborah_NY

How do I hide spreadsheet range from data entry?
 
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??

[email protected]

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.



All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com