Restricting/directing tabs

**valius** · 03-09-2010, 10:22 AM

Hi all,

Looking for some advice in respect of restricting access to tabs on a shared workbook.

I have 14 tabs - one for each user. We are on a network so each user has a unique id. I would like to add some code (form of Auto Open?) which would mean that when a user opens the sheet they are taken directly to a specified tab (their own) depending on their network login id. My intention would then be to hide the tabs so that they cannot accidentaly select the wrong tab and update someone elses information.

I'm sure it can be done as a friend advised he used this method on something he worked on. Unfortunatley he on holiday so I cant pick his brains! I've googled at this for a while without joy.

Closest I have come is "allow users to edit ranges" which does work to an extent but I'd really prefer the method above.

All help appreciated.

**dominicb** · 03-09-2010, 10:49 AM

Good afternoon valius

I have a template available that does exactly what you require. It stores a list of users and passwords, and which sheets are to be accessed by which users. You, as administrator, can see all worksheets and control which sheets users can access.

The security on this isn't 100%, as we are using Excel, which by its very nature is not completely secure, but it should keep out most nosey parkers.

If you prefer to write something of your own, then all my code is unprotected, so you could use that to get some ideas, or fine tune the workings.

If you would like a copy of this template, then please PM me your e-mail address.

HTH

DominicB