Complicated question, for me anyway! :)
Hi-
I was wondering if someone can help me.
Is it possible, in an excel worksheet, to lock each different sheet with a
password.
I do not mean for editing purposes, i mean for visibility purposes, as in;
unless one of my employees has the required password they will not be able to
see the different parts of the whole worksheet.
My reason for asking is i am creating a holiday tracker for different parts
of my business and i do not want each department to see what each others
holiday entitlements are, please let me know if any further clarity is needed.
Many thanks,
Peter
|