Toggle and command buttons

[Kwarren]

Is it possible to create a toggle or command button that will hide and unhide a column without the use of macros?

Thanks, Kirk

[martindwilson]

nope! no way

[JBeaucaire]

You can use the GROUP function for that.

Highlight columns C:D and then select Data > Group & Outline > Group. A minus sign will appear above column E you can use to toggle the visiblitly of those columns.


That works for a single columns, too

[martindwilson]

well apart from that!!!! but it just confuses anyone who doesn't know about it lol