make a cell into a button

  • Thread starter Thread starter RGlade
  • Start date Start date
R

RGlade

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.
 
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

========================================================================
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.
Click to expand...

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

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

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1
 
Back
Top