Open your work book that contains the command buttons and press Alt+F11 to
open the VBE (Visual Basic Editor) and search to see if there are any modules
containing VBA code that hides/unhides columns. If not, right click on any
visible toolbar and select the Control Toolbox toolbar.

On this tool bar is a design button that has a triangle/pencil/ruler icon,
click this to go into design mode. Right clck on one of your command buttons
and select View Code from the short cut menu. The macro code may be assigned
to the button.

--
Kevin Backmann


"mnt" wrote:

Someone sent me a workbook with a worksheet that has an area above the column
heading letters in which two buttons appear. These buttons are labeled 1 and
2. Clicking on 2 displays rows that are hidden and shows a spanning line
over those columns. Clicking on 1 hides those rows.

I've searched for Custom Views, macros, etc. and can't find anything that is
the definition of these buttons. How can something like this be created? I
can email a jpg of the worksheet to show the buttons, if this is not clear.

Thanks.