Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i create a button within a spreadsheet
I want to create some buttons within the spreadsheet so that i can select a
cell then hit the button and highlight the selected cell a certian color |
#2
|
|||
|
|||
Brian, there is one on the formatting tool bar already, looks like a paint
can, fill color, will that work? If not you could use a macro something like this and assign it to a button, view, toolbars, forms, click on the button then click on your sheet, assign the macro to it Sub Color_Yellow() With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Brian" <Brian @discussions.microsoft.com wrote in message ... I want to create some buttons within the spreadsheet so that i can select a cell then hit the button and highlight the selected cell a certian color |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a print button? | Excel Worksheet Functions | |||
How Do I create a spreadsheet with a finite set of columns and ro. | New Users to Excel | |||
Can I create custom forms to add data to a Excel Spreadsheet? How. | Excel Discussion (Misc queries) | |||
How do I create a daily spending spreadsheet in Excell? | Excel Worksheet Functions | |||
How do I create a macro button and place anywhere on my sheet? | Excel Discussion (Misc queries) |