You have to click on the control in the ribbon to redisplay the palette,
because it closes every time you use it.
In earlier versions you could actually drag the palette off the toolbar
and place it next to where you were working.
This change was one of the "enhancements" that the 2007 UI astronauts
imposed on us. Impediments is more like it, because it contributes to
the overall productivity decline among Excel 2007 users.
Solution: just create a few simple macro's in your PERSONAL.XLSB like this:
Sub CellGreen()
Selection.Interior.ColorIndex = 43
End Sub
Sub CellYellow()
Selection.Interior.ColorIndex = 44
End Sub
Sub CellOrange()
Selection.Interior.ColorIndex = 46
End Sub
Sub CellRed()
Selection.Interior.ColorIndex = 3
End Sub
then link them in your Quick Access Toolbar to the colored icons available
Regards,
Robert Ilbrink
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.