OK, I've tried and failed utterly to work this out.
What I have is a workbook that comprises 4 worksheets: An instruction sheet, a 'Blank' sheet, a Staff sheet and a totals sheet. It is used by staff to record annual leave.
Each member of staff has their own sheet that is created by entering their details onto the Staff sheet (Name, Password and initials). A sheet is then automatically created that uses the member of staffs initials as a title (tabe name). The sheet is a copy of the Blank sheet.
To access their sheet, the member of staff logs in using their name and the password they have been allocated, which then allows them access to only their sheet (the remaining sheets are kept veryhidden.
(I will attach an example later. I actually created it using VB I found all over this site that I've adjusted to ensure that it works nicely together. So thanks).
This works fine for most people, however I'm experiencing a number of difficulties with the workbook, specifically with people not being able to access the spreadsheet correctly and experiencing huge lags in access time.
Also, every so often there is a glitch that exposes everyone's sheet, meaning that everyone can see all the sheets when they log in.
I was wondering if there was anyway that instead of password protecting the system to effectively keep all the other sheets hidden it was possible to create a Front sheet in a separate workbook, containing a single sheet. People could then log into this Front sheet and their data would be 'pulled', from their specific sheet on the Master System into the front sheet so that the information on it could be adjusted, added to, and could then be 'saved' back to the original workbook. I wouldn't then have to worry about all sheets becoming visible.
Am I making any sense?
Bookmarks