Gord - Thanks for breaking it down - Appreciate all the other help that was
offered but it was greek - I can handle your steps....

Thanks

"Gord Dibben" wrote:

George

I think you misunderstood Arvi's method which was to use VBA code to hide the
worksheet then protect the VBA code so's users could not get to it.

For the casual user.........just hide the worksheet under FormatSheetHide.

Then from ToolsProtectionProtect Workbook.

Protect Windows and Structure then password it.

Users can see all sheets but the hidden one and cannot unhide without the
password to unprotect the workbook. This protection is different from the
File Protection you currently have and can be in addition to that.

For the not-so-casual user employ VBA's VeryHidden method..........

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Worksheets("Sheet1").Visible = xlVeryHidden
End Sub

To unhide the sheet when you want to edit.

Sub unhide()
Worksheets("Sheet1").Visible = True
End Sub

You can set a password on the VBA Project.

Be aware that passwords can be cracked, sheets and workbooks are quite easy.
Files and VBA Projects less so.


Gord Dibben Excel MVP

On Thu, 31 Mar 2005 07:31:12 -0800, George
wrote:

Tried your suggestion - The work book is password protected, they use read
only to open - so I signed in and selected Hide - which it did. Then I closed
the spread sheet and reopened as Read Only and anyone can go to Format
Unhide, so that doesn't provide any security for that sheet.

Thanks - Is there another way to keep this sheet locked ?

"Arvi Laanemets" wrote:

Hi

Select sheet. From Format menu select Sheet.Hide
But any user can make it reversible, i.e. to set the sheet visible again. to
avoid this, you have to open VBA editor (Press Alt+F11), and set the Visible
property for sheet to VeryHidden. Protect the VBA-project with password
after that, and you have got maximum what's possible in Excel.


Arvi Laanemets



"George" wrote in message
...
On my spread sheet I have several tabs I created at the bottom of the work
book. I need to share this work book with everyone but there's one tab I
want
to password protect, is that possible ?

Thanks - George