I reply it...
I hope that someone anwers to me...
I have that problem (excuse me for my english)..
Why in sheet "me" I can use:
.Range(Columns(15), Columns(17)).Hidden = False
and in another sheets can't I?
I used a For cycle to do it!
For k = 18 To 20
.Columns(k).Hidden = False
Is there another way to hidden a range of columns in another sheets?
How can I hidden that columns(15,16,17 e 21) in another sheets wit
only row of code?
Thanks
Francesco
ToggleButton3.Caption = "Nascondi Previsioni"
With Me
.Range(Columns(15), Columns(17)).Hidden = False
.Range(Columns(6), Columns(7)).Hidden = True
.Columns(22).Hidden = False
.Columns(18).Hidden = True
.ToggleButton4.Visible = True
End With
For i = 4 To 12
For k = 18 To 20
For t = 6 To 8
With Sheets(i)
.Columns(k).Hidden = False
.Columns(t).Hidden = True
.Columns(25).Hidden = False
.ToggleButton2.Visible = True
End With
Next
Next
Nex
--
fragher7
-----------------------------------------------------------------------
fragher75's Profile:
http://www.excelforum.com/member.php...fo&userid=1236
View this thread:
http://www.excelforum.com/showthread.php?threadid=25920