View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default How do I auto expand hidden rows or columns?

Sub togglehideunhidecolumns()
Columns("b:d").Hidden = True = Not Columns("b:d").Hidden
End Sub

--
Don Guillett
SalesAid Software

"iamjbunni" wrote in message
...
I am creating a presentation and I am including 3 topics. I want to allow
the user to expand the hidden columns with a single click and hide them
again
when they are done viewing that portion. How do I do this?

Thank you for your time!