View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hoshyar Hoshyar is offline
external usenet poster
 
Posts: 25
Default how can hide and show columns using macro?

How can I unhide hidden columns and then hide them again by macro? suppose
that I have a workbook made of 10 columns. colum 3,4 and 5 are hidden by
default. I want to unhide these hidden columns when I type word "AB" in any
cell in colum Number 1. and then by pressing enter I want to hide these
columns again. is this possible using macro?

Many thanks
Hoshyar