[Year 12 IT Apps] An excel Problem

[Damien A-B]

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

Cheers

Damien Atkinson-Buck

IT Department

Keilor Downs College


  _____  

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
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
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)
 
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 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,
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,
and not necessarily those of the Department of Education.

_______________________________________________ 
http://www.edulists.com.au  <ttp://www.edulists.com.au> - FAQ, resources,
subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au  <ttp://www.vcaa.vic.edu.au> - Victorian
Curriculum and Assessment Authority and 
http://www.vitta.org.au  <ttp://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, 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, and not necessarily those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070604/978c03a1/attachment.html