<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007><FONT face=3DAr=
ial
color=3D#0000ff size=3D2>Hi Colin,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007> &nb=
sp; <FONT
face=3DArial color=3D#0000ff size=3D2>Try this instead of selecting them fir=
st, then
hiding them.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D812385903-04062007><FONT face=3DAr=
ial
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=3DAr=
ial
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<?xml:names=
pace
prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office"
/><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"><?xml:namespace prefix =
=3D st1 ns =3D
"urn:schemas-microsoft-com:office:smarttags" /><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></st=
1: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></SPAN=
></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> itapps-bounces@edulists.com.au
[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 IT=
Applications Teachers' Mailing List<BR><B>Subject:</B> [Year 12 IT Apps] An=
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 s=
tumping
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 e=
xcel
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 or=
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 c=
an
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 o=
r
using attachments check them for viruses and defects. Regardless of any loss=
,
damage or consequence, whether caused by the negligence of the sender or not=
,
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, an=
d
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>- Victorian Curriculum and Assessment Authority and <BR><A
href=3D'ttp://www.vitta.org.au"'>http://www.vitta.org.au </A>- VITTA Victori=
an
Information Technology Teachers Association Inc <p></p><p><b>Important - </b=
>This email and any attachments may be confidential. If received in error, p=
lease contact us and delete all copies. Before opening or using attachments=
check them for viruses and defects. Regardless of any loss, damage or conse=
quence, whether caused by the negligence of the sender or not, resulting dir=
ectly or indirectly from the use of any attached files our liability is limi=
ted 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></BODY></HTML>