Very Hidden

Hi, I've got a workbook from someone with a veryhidden
worksheet that I need to get to. When I try and set the
properties to either visible or just hidden I get a
message 'Unable to set the visible property of the
worksheet class'

This sheet has got some complex formula on that need
ammending to make the front sheet work.

I've got two questions. A) How can I make it visible? B)
Its quite cool, how do I do this to other worksheets?

cheers

John

Hi John

I believe your Workbook is protected. It's done to prevent unhiding and
renaming sheets.

Hide sheets with a macro like thi:

Sheets(2).Visible = xlVeryHidden

HTH. Best wishes Harald

skrev i melding
...
Hi, I've got a workbook from someone with a veryhidden
worksheet that I need to get to. When I try and set the
properties to either visible or just hidden I get a
message 'Unable to set the visible property of the
worksheet class'

This sheet has got some complex formula on that need
ammending to make the front sheet work.

I've got two questions. A) How can I make it visible? B)
Its quite cool, how do I do this to other worksheets?

cheers

John

Hi

To make sheets xlveryhidden, you must use code.
You cannot make all sheets xlveryhidden. One sheet must be visible.

an example,

Private Sub CommandButton1_Click()

For i = 2 To Sheets.Count
Sheets(i).Visible = xlVeryHidden
Next i


End Sub


Will hide all sheets but sheet 1


while

Private Sub CommandButton2_Click()

For i = 2 To Sheets.Count
Sheets(i).Visible = True
Next i


End Sub


will unhide all hidden sheets.


HTH

Ken


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.744 / Virus Database: 496 - Release Date: 24/08/2004

Hi

And Harald as usual is right. The sheets and wb must not be protected when
you do this.

Ken


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.744 / Virus Database: 496 - Release Date: 24/08/2004