Hidden Sheets 2

[Yogi39]

I've come across the term very hidden refering to worksheets in an Excel workbook....

I see how to hide a worksheet.
How can one make a sheet very hidden(that is no available when one uses the unhide through the format sheet menu?

 

[DaleWatson123321]

Yogi,

Perhaps there are additional options, but this one is the "usual" method - of ensuring that a user cannot gain access to a Hidden Sheet.

Simply use Tools - Protection - Protect Workbook.

Be sure to "write down" your password.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Yogi39]

Thanks Dale,
PS : This MS Knowledge Base was also interesting !

XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro (Q213609)

 

[MattSmithProg]

Hi Yogi

You can also make a sheet very hidden by entering the VBA environment (Shift + F11). Then check out the properties of the individual sheets. You have the option in there of visible, hidden or very hiddden.

Very hidden means that it is not available and also not visible (unlike the method above) to the user through the front end of Excel, ie through the format/sheets menu.

If you don't want any one to make the sheet visible through VBA then you will need to place a password on the VBA code.

To do this be in the VBA environment, go to Tools, VBA project Properties and then click on the Protection tab. You then have the option of placing a password in here.

Once again don't forget it.

Hope this helps

Matt

 

[Yogi39]

Sure Does...
Thanks !

 

[SkipVought]

NOTICE:

The Properites that you can assign to a Contributor are...

   With Contributor
      .Indifferent
      .Greatful
      .VeryGreatful
   End With

and don't forget

Contributor.VeryGreatful.Star = TRUE

;-) Skip,
metzgsk@voughtaircraft.com

 

[Yogi39]

Sub sheet()
Sheets.Add.Name = "sss"
Sheets("sss&quot.Visible = xlVeryHidden

End Sub

can I combine these two sheets commands ?

 

[DaleWatson123321]

Thanks guys,

I knew you would come through with the additional methods.

Thanks, and a "serving of STARS"

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[SkipVought]

I don't think so. You are starting out with the Sheets Collection. There are n Sheets in the Sheets Collection.

When you perform Sheets.Add...
you are adding to the Sheets Collection, so that NOW the sheet count is n+1.

Think that you (we) are stuck with 2 statements. ;-) Skip,
metzgsk@voughtaircraft.com

 

[Yogi39]

Cool....Thanks !

 

[euskadi]

You can also "very hide" a worksheet by choosing View/Toolbars/Control toolbox and clicking on the "view properies" button, then select "very hidden" from the drop down box.

Of course, you'll then need to use one of the VB tricks above to bring the sheet back, but if all you want to do is hide it without using code, that'll do it.