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.
|