ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combined use - drop-downs, filters, protect sheet (https://www.excelbanter.com/excel-worksheet-functions/204548-combined-use-drop-downs-filters-protect-sheet.html)

Jo Ann

Combined use - drop-downs, filters, protect sheet
 
Want to protect columns A & B (year & report number being taken by user)
Have Drop-downs (w/ values on separate sheet) in Columns C, F, G, H
Also want to protect data that's entered in all columns (except A & B). Once
data is entered & user exits file, can that data be protected? Want to do
this so that with multiple users, one cannot inadvertently change the data.
All users are on a PC platform w/ possibly 2 different operating systems. I
have Windows XP and using Excel 2003



All times are GMT +1. The time now is 09:27 PM.

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