How to auto hide and unhide columns using 1 and 2 icons

R

R. Rebello

While working on a worksheet some of the columns set into auto hide and
unhide mode. Columns can be hidden or unhidden through 1 and 2 icons.
Please explain the procedure to set such functions.
 
D

David D

You should be able to record macros that will hide (or unhide) the currently
selected column. Then you can create icons for your new macros and place
them on your toolbar.

If you're looking for something more automated, that hides columns based on
some values, you'll have to create a more complex macro that evaluates each
column in the active sheet and then hides it (or not). If you could tell me
more about what you're doing, perhaps post your file, I could probably help.
 

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

Top