User friendly?? Who knows but I have colleagues that manage to do - anything (even though they shouldn't be able to)....
Therefore I'm know wondering if it is possible to set users that are allowed to enter text in a sheet?
I have a workbook were colleagues fill in data in 'their' sheet.
Sheet names: "KES"; "KAD"; "LHA" etc...
I'd like to set a parameter for each sheet which users are allowed to make changes whereas I "DOL" works as a "admin" and can make changes on all.
Sheet named KES can be changed by: KES or LHA or DOL
Sheet named KAD can be changed by: KAD or DOL
Sheet named LHA can be changed by: LHA
Other sheets not specified can be changed by any user.
Is this possible?? Any ideas?
All the best,