<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =3D "urn:schemas-microsoft-com:office:office" xmlns:st1 =3D
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16441" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Yes that worked.......Thanks Damien!</FONT>=
</DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Cheers,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Colin White</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ICT Director</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Heywood & District Secondary
College</FONT></DIV></FONT></DIV>
<BLOCKQUOTE
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEF=
T: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From=
:</B>
<A title=3Dbuck.damien.j@edumail.vic.gov.au
href=3D"mailto:buck.damien.j@edumail.vic.gov.au">Damien A-B</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A title=3Ditapps@edulists.com.=
au
href=3D"mailto:itapps@edulists.com.au">'Year 12 IT Applications Teachers'=
Mailing List'</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, June 04, 2007 2:01 PM=
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: [Year 12 IT Apps] An e=
xcel
Problem</DIV>
<DIV><BR></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007><FONT face=3D=
Arial
color=3D#0000ff size=3D2>Hi Colin,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007> &=
nbsp;
<FONT face=3DArial color=3D#0000ff size=3D2>Try this instead of selecting=
them
first, then hiding them.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007><FONT face=3D=
Arial
color=3D#0000ff size=3D2>Worksheets("Sheet1").Columns("E:F").Hidden =3D
True<BR>Worksheets("Sheet1").Columns("J:O").Hidden =3D
False<BR>Worksheets("Sheet1").Columns("K:L").Hidden =3D True</FONT></SPAN>=
</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007><FONT face=3D=
Arial
color=3D#0000ff size=3D2>etc</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007></SPAN> =
</DIV>
<DIV align=3Dleft>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Cheers<o:p></o:=
p></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Damien
Atkinson-Buck<o:p></o:p></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">IT
Department<o:p></o:p></SPAN></P>
<P class=3DMsoNormal style=3D"MARGIN: 0cm 0cm 0pt"><st1:place
w:st=3D"on"><st1:PlaceName w:st=3D"on"><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Keilor</SPAN></=
st1:PlaceName><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> <st1:PlaceName=
w:st=3D"on">Downs</st1:PlaceName> <st1:PlaceType
w:st=3D"on">College</st1:PlaceType></SPAN></st1:place><SPAN
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p></o:p></SP=
AN></P></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> <A
href=3D"mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com=
.au</A>
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Colin
White<BR><B>Sent:</B> Monday, 4 June 2007 12:57 PM<BR><B>To:</B> Year 12 I=
T
Applications Teachers' Mailing List<BR><B>Subject:</B> [Year 12 IT Apps] A=
n
excel Problem<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a perplexing excel problem that is=
stumping me.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to hide several columns in an=
excel
spreadsheet by either a macro or preferably a VB control button. I have 3=
buttons to show or hide certain columns, but it either hides all columns o=
r no
columns (depending on which button is clicked)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have attached the file.....hope someone=
can
help!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Cheers,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Colin White</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ICT Director</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Heywood & District Secondary
College</FONT></DIV>
<P></P>
<P><B>Important - </B>This email and any attachments may be confidential.=
If
received in error, please contact us and delete all copies. Before opening=
or
using attachments check them for viruses and defects. Regardless of any lo=
ss,
damage or consequence, whether caused by the negligence of the sender or n=
ot,
resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,=
and
not necessarily those of the Department of
Education.</P>_______________________________________________ <BR><A
href=3D'ttp://www.edulists.com.au"'>http://www.edulists.com.au </A>- FAQ,=
resources, subscribe, unsubscribe <BR>IT Applications Mailing List kindly=
supported by <BR><A
href=3D'ttp://www.vcaa.vic.edu.au"'>http://www.vcaa.vic.edu.au </A>- Victo=
rian
Curriculum and Assessment Authority and <BR><A
href=3D'ttp://www.vitta.org.au"'>http://www.vitta.org.au </A>- VITTA Victo=
rian
Information Technology Teachers Association Inc
<P></P>
<P><B>Important - </B>This email and any attachments may be confidential.=
If
received in error, please contact us and delete all copies. Before opening=
or
using attachments check them for viruses and defects. Regardless of any lo=
ss,
damage or consequence, whether caused by the negligence of the sender or n=
ot,
resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,=
and
not necessarily those of the Department of
Education.</P>_______________________________________________ <BR><A
href=3D'ttp://www.edulists.com.au"'>http://www.edulists.com.au </A>- FAQ,=
resources, subscribe, unsubscribe <BR>IT Applications Mailing List kindly=
supported by <BR><A
href=3D'ttp://www.vcaa.vic.edu.au"'>http://www.vcaa.vic.edu.au </A>- Victo=
rian
Curriculum and Assessment Authority and <BR><A
href=3D'ttp://www.vitta.org.au"'>http://www.vitta.org.au </A>- VITTA Victo=
rian
Information Technology Teachers Association Inc </BLOCKQUOTE><p></p><p><b>=
Important - </b>This email and any attachments may be confidential. If recei=
ved in error, please contact us and delete all copies. Before opening or usi=
ng attachments check them for viruses and defects. Regardless of any loss, d=
amage or consequence, whether caused by the negligence of the sender or not,=
resulting directly or indirectly from the use of any attached files our lia=
bility is limited to resupplying any affected attachments. Any representatio=
ns or opinions expressed are those of the individual sender, and not necessa=
rily those of the Department of Education.</p></BODY></HTML>