View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Doak Peter Doak is offline
external usenet poster
 
Posts: 1
Default 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