Multiple users of a single wookbook

[Dave]

In the past I have created six identical copies of a workbook for six
different users and then hidden sheets not relevent to each user.

Does anyone know how I could have a single workbook accessible to six
users but each individual only able to see the sheets relevent to
them.

TIA

Dave

 

[StarTrek an beyond]

Dave, I found this at
http://www.exceltip.com/st/Hide_an_excel_sheet_without_the_option_of_unhidin
g_it_using_VBA_in_Microsoft_Excel/619.html,
so I can not take credit.
---- Clip---
To hide a sheet so that no body can unhide it without knowing the password
<http://www.exceltip.com/search/password.html> for the Vb Project, simply
open the VB Editor and change the visible property to 2 i.e.
xlsheetveryhidden.
The sheet should disappear from the Unhide sheets command.
The only way to unhide it is to change the property back to 0 i.e.
xlSheetNormal using the password to the VBProject.
---- un Clip---
After practicing on one of my books, it works:

Right click the sheet and View Code. That will bring up the Editor. Click
the book you are working in and the open up the VBA code by click the +.
Click the sheet and then F4 to open the properties sheet. At the bottom of
that window is the Visible property. Change the -1 to either 0 or 2 to hide
the sheet. DO NOT FORGET THE PASSWORD.

HTH

Wayne Bork

 

[Dave]

Thanks for that. I have three sheets in the workbook which I want
no-one else able to see, or tamper with, and I think I will make those
veryhidden. But what I was looking for is somthing simpler than that.
It's not realy a security issue but for the convenience of the other
users. The workbook has about thirty sheets, far too many to display
on the screen at once. Each user only needs to see five or so. I
wanted a way of having the workbook displayed six different ways for
the six different users.

Dave

 

[StarTrek an beyond]

30 sheets is a lot for one workbook.
With a little more investigation I found a very easy way, & from the HELP.

clip
Hide a sheet
1. Select the sheets you want to hide. How?
2. On the Format menu, point to Sheet, and then click Hide.
unclip

The difference with this is that anyone can unhide any sheet. So if you
don't mind that, then this would be the simplest way to hide the sheets.

You can also protect a sheet or workbook. Search in help for "Protect a
workbook or sheet"

Wayne B