View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DJ Ghale DJ Ghale is offline
external usenet poster
 
Posts: 1
Default Blocking/Disabling selected worksheet

I created an excel file for payroll purpose with each employee's pay info
broke down in separate worksheets. Is there a way i can disable or hide other
worksheets so that each employee can only view their own worksheet? (maybe
set a password protection?) I have the option to save each worksheet in a
different workbook and send it as an email attachment but i don't want to
waste time sending 20 different emails with attachments if there's an easier
way to do this. Thanks in advance.