Buttons

[John Lake]

I am using excel 2000 on win xp.

Have created a spredsheet of clothing inventory. Is it
possible to have buttons at the top of the page i.e.
inches and cms that when clicked on will display the
clothing sizes in either inches or cms?? or is there a
better way all together??

Would be very grateful of your help.

Many thanks

John Lake

 

[icestationzbra]

just a suggestion - it might be easier if you consider having tw
separate columns, one with inches and one with centimetres

 

[Frank Stone]

to do as you want, you might have to create 2 columns with
inched in one column(example column K) and cms in the other
(example column L).
You could then creat a button and put this code behind it.
sub macShowHideColumn
If Columns("L:L").Hidden = True Then
Columns("K:K").Hidden = True
Columns("L:L").Hidden = False
Else
Columns("K:K").Hidden = False
Columns("L:L").Hidden = True
End If
end sub
This code would cause one of the columns to be hidden.
clicking the button would unhide the hidden column and
hide the unhidden column.