View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moosa Abrahams moosa Abrahams is offline
external usenet poster
 
Posts: 1
Default Hide columns with certain coditions


Hi there
I need to hide some columns in excel 2003

example

question in row A1 answer in Row A5
iF THE ANSWER IN a5 is positive then columns d-f must be visible or active
If the answer is negative row D-F should be hidden

My excel knowhow is medium

Any help will be appreciated

Mo


EggHeadCafe - Software Developer Portal of Choice
..NET Remoting - Marshal Objects ByRef
http://www.eggheadcafe.com/tutorials...marshal-o.aspx