Very Hidden

[Guest]

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

 

[Harald Staff]

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

 

[Ken Macksey]

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

 

[Ken Macksey]

Hi

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

Ken