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?? |
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