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

G

Guest

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.
 
G

Guest

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

Similar Threads

Hide/Unhide with cell double click 4
Using Hide, Unhide, and auto filter - select all on a protected sh 1
How do I hide and unhide the same columns without reselecting 2
Non cumbersome way to hide and protect a column? 2
Hide Unhide Buttons 3
Hide Unhide Button 4
Checkbox to hide and unhide rows Please. 2
Macro to Hide/Unhide various columns 5

Top