Spread Sheet Tabs

G

George

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
 
C

CLR

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

Vaya con DIos,
Chuck, CABGx3
 
G

George

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

Thanks
 
A

Arvi Laanemets

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
 
G

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 ?
 
G

Gord Dibben

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
 
Top