One of the recurring suggestions is to hide all but a 'Welcome' sheet
in the ThisWorkbook close event. using
Sheets("Sheet1").Visible = xlVeryHidden
You can do this with all but one of the sheets. With xlVeryHidden the
sheets can only be viewed through code, not through Format Sheets
You can loop through the sheets to do this.

Than you can have code that will show selected sheets based on a
password. In your code you can use a Select Case structure to respond
to different passwords and unhide the relevent sheets.

Just remember to protect you code in the VB Editor to prevent users
getting in and 'messing'.

But keep in mind that Excel is not that secure. And someone could write
code in another workbook to unhide your sheets.

Post back if you need more help...

--
sb
"peterlee516" wrote in message
...
Hey guys...This is a great site. I know it would be very helpful if I
understood what everyone was talking about.

You guys seem to know what you are doing. Would you guys help me with
disabling the Sheet option under the Format menu?

Or a way to disable a sheet not hide.

Basically I am trying to set it up so that users can put in a password
and only view what they are aloud to view and disable the rest. I don't
want to just hide the sheets just in case they know how to unhide
sheets, which I doubt.

Is there a disable function for sheets?

Thanks a lot.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/