Bring up the Control Toolbox toolbar (Tools - Customize - Toolbars -
Control Toolbox). Click on the Button icon and then click on the worksheet to
place one on your sheet. Right click the button and select Properties. Change
the Caption to something like Hide/Unhide. Double click on the button. This
will take you to the code window. Add something like the following the the
code that was added for you...

Private Sub CommandButton1_Click()
Columns("B:C").Hidden = Not Columns("B:C").Hidden
End Sub
--
HTH...

Jim Thomlinson


"Wendy" wrote:

OK - I know - This is probably a basic questions for you experts, but I would
like to know how to add buttons to a worksheet that hide and unhide specific
colums, and how these commands/buttons are created.

I have inherited a workbook that someone else created, and now I need to add
more data to it in the same manner as the original author.