How do I auto expand hidden rows or columns?

G

Guest

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!
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and Shrink Rows and columns to hide information. 1
how do i paste rows/columns avoiding hidden rows/columns 1
Can I expand & shrink columns? 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
I cannot delete the extra rows or columns in Excel 2007 2
Excel help for hidden columns 3
How do I display a list of the rows or columns that I've hidden? 1
Why do hidden columns/rows unhide automatically? 1

Top