You can have a sign-in sheet that would display when the file is opened.
You could then have a drop-down in a cell that would display all the names.
The user would select a name (his own, presumably) and his sheet would be
displayed. But what is there to prevent him from selecting another name
than his own? Well, Excel could ask for a password. All of this would be
based on the sheets being VeryHidden, a concept that would require the user
to have some knowledge of VBA programming to defeat. But be aware that
Excel is not built to be a secure platform. To the casual user yes. To the
knowledgeable user, no. Come back if you want to pursue this further. HTH
Otto

"McChas" wrote in message
...
I have a workbook with 10 spreadsheets. Each sheet/tab is for individual
employees. Is there a way to have a user sign in and only view their own
tab
and not gain access or even hide the other employees sheets/tabs?