make a cell into a button
 

How do I make a cell into a "button"?
I want to format the cell,
make it into a button that references another cell
and then lock the button so others can't manipulate it, while still being
able to select it.

Thank you for your quick response.

make a cell into a button
 

Hi,

You can either add a button from the Control toolbar and place it over your
cell or use the code below which will fire everytime you change the cell you
click on...propper button would be the best option tho.

HTH

Simon

================================================== ======================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
MsgBox "YOUR CODE HERE"
End If
End Sub

================================================== ======================

RGlade wrote:
How do I make a cell into a "button"?
I want to format the cell,
make it into a button that references another cell
and then lock the button so others can't manipulate it, while still being
able to select it.

Thank you for your quick response.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1