Spread Sheet Tabs
 

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

Select the tab, then do Tools Protection Protect Sheet and follow the
menu.........

Vaya con DIos,
Chuck, CABGx3


"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

Tried suggestion - sheet still opens when tab is clicked on - don't want
people to be
able to see contents.

Thanks


"CLR" wrote:

Select the tab, then do Tools Protection Protect Sheet and follow the
menu.........

Vaya con DIos,
Chuck, CABGx3


"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

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

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

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

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

Thanks for the feedback.

Sometimes(most times) we all say exactly the same thing in a different manner.

What's good about that is that the original poster gets more than one slant on
a suggestion.

It depends on whether you are a right-sider or left-sider which slant is the
most comprehensible.


Gord

On Thu, 31 Mar 2005 17:49:03 -0800, George
wrote:

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

Hi Dord

Actually no VBA code was meaned. In VBA-Project window you can set
properties for every sheet manually too. Protecting after that the project
(having any code or any module at all in VBA-project isn't essential)
prevents further access to whole project - properties window (lower left one
when activated) included.

To set any properties manually, you must have Properties window activated -
when not then activate it from View menu. Then in VBA-Project window select
the sheet, and in properties window set the properties for selected sheet.
When ready, right-click on VBA-Project object in VBA-Project window, select
VBA-Project Properties and then Security, and set the password.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

Arvi

Thanks for the update on this.

Was not thinking about setting the sheet to veryhidden in this manner.

Good advice and an easy method once explained as you have.

Was me who misunderstood your original post.

I just keep on learnin'


Gord

On Fri, 1 Apr 2005 08:11:10 +0300, "Arvi Laanemets" wrote:

Hi Dord

Actually no VBA code was meaned. In VBA-Project window you can set
properties for every sheet manually too. Protecting after that the project
(having any code or any module at all in VBA-project isn't essential)
prevents further access to whole project - properties window (lower left one
when activated) included.

To set any properties manually, you must have Properties window activated -
when not then activate it from View menu. Then in VBA-Project window select
the sheet, and in properties window set the properties for selected sheet.
When ready, right-click on VBA-Project object in VBA-Project window, select
VBA-Project Properties and then Security, and set the password.