Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a clickable button to do a Key Combo? | Excel Worksheet Functions | |||
Make a 'Print button' | New Users to Excel | |||
use "button" to make calculation ignore a cell | Excel Worksheet Functions | |||
How can I make the save button available from the openoffice? | Excel Discussion (Misc queries) | |||
Is it possible to make a Button on a tool bar to launch an Add-in | Excel Discussion (Misc queries) |