[Year 12 IT Apps] An excel Problem

[Colin White]

Yes that worked.......Thanks Damien!

Cheers,
Colin White
ICT Director
Heywood & District Secondary College
  ----- Original Message ----- 
  From: Damien A-B 
  To: 'Year 12 IT Applications Teachers' Mailing List' 
  Sent: Monday, June 04, 2007 2:01 PM
  Subject: RE: [Year 12 IT Apps] An excel Problem


  Hi Colin,
      Try this instead of selecting them first, then hiding them.
  Worksheets("Sheet1").Columns("E:F").Hidden =3D True
  Worksheets("Sheet1").Columns("J:O").Hidden =3D False
  Worksheets("Sheet1").Columns("K:L").Hidden =3D True
  etc

  Cheers

  Damien Atkinson-Buck

  IT Department

  Keilor Downs College




----------------------------------------------------------------------------=
--
  From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.a=
u] On Behalf Of Colin White
  Sent: Monday, 4 June 2007 12:57 PM
  To: Year 12 IT Applications Teachers' Mailing List
  Subject: [Year 12 IT Apps] An excel Problem


  Hi All,

  I have a perplexing excel problem that is stumping me.

  I am trying to hide several columns in an excel spreadsheet by either a ma=
cro or preferably a VB control button. I have 3 buttons to show or hide cert=
ain columns, but it either hides all columns or no columns (depending on whi=
ch button is clicked)

  I have attached the file.....hope someone can help!

  Cheers,
  Colin White
  ICT Director
  Heywood & District Secondary College

  Important - This email and any attachments may be confidential. If receive=
d in error, please contact us and delete all copies. Before opening or using=
 attachments check them for viruses and defects. Regardless of any loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.

  _______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  IT Applications Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority=
 and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers=
 Association Inc 

  Important - This email and any attachments may be confidential. If receive=
d in error, please contact us and delete all copies. Before opening or using=
 attachments check them for viruses and defects. Regardless of any loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.

  _______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  IT Applications Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority=
 and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers=
 Association Inc 
Important - 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 loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070604/9821fbf3/attachment-0001.html