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 |
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 |
All times are GMT +1. The time now is 07:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com