Shared Workbook - enble user to see only their own sheet
Posted by Alix on March 05, 2001 9:01 AM
I am creating a time-keeping workbook for a small team in my office. This will run from a single shared workbook in which each user will have their own sheet.
I want each person's data to be hidden from other users and therefore have created a login page where they select a button to unhide their sheet. Unfortunately, this obviously means that they can also unhide anyone else's sheet.
Protecting the individual sheets with passwords does not stop this as I don't need the password to unhide the sheet. So I need a way of preventing a sheet being unhidden unless the correct password is entered.
Many thanks in advance for any help