Shared Workbook with user code lookup to display sheets

[Mark Warner]

I want to make a shared workbook that will have 100 tabs (each an
individual's timecard) which are all hidden on entry. Only 1 page visible,
HOME, where user inputs their social security number and either on enter or
click a lookup process happens to figure out which sheet to unhide. User
then inputs data, presses save and close buttons on sheet which hides tab
again and returns the user to HOME. On HOME there is a button that will
cleanup, make sure all sheets are hidden and exit the workbook.

And to make it harder, supervisors will need to have multiple sheets
unhidden so they can review them and approve.

thanks.

 

[NickHK]

Mark,
All that is possible with relatively simple coding. But you are asking a lot
of contributors to create it all for you.
If you made a start and came back when you have a specific question, others
would help.

Bear in mind :
- If you are searching by SSN, it would easier to name you worksheets with
this.
- You can generate/use a list of worksheets with :
Dim WS as worksheet
for each ws in worksheets
'do something
'e.g. If WS.name=SSN then WS.Select
next
- Excel security is, at best, a minor inconvenience for anyone with a minute
and a little curiosity.
If a user really should not see the others' information, don't include it in
the file.
Otherwise, expect that sooner or later, one of your users will have the
inclination to snoop.

NickHK

 

[Shaka215]

Mark,

Contact me if you want this designed...I can make this for you no
problem...I would like to extend my services to you, so please feel
free to get in contact with me. You can reach me at my e-mail address
below.

(e-mail address removed)

Thank you!