Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Access Toolbar questions
I just bought Office 2007, and I have two questions regarding Quick Access
Toolbars. 1. I use Excel frequently, and I am taking advantage of the quick access toolbars (below the ribbon). Unfortunately, when you insert commads to QAT, command icons without pre-assigned graphic appear as "green dots", i.e. paste formula and paste value commands. Is there a way to change this - I don't know why MS do not provide tools to solve this proble, like custom icon designer. 2. Under the same heading, when I add command in "Customizing the QAT" section, I noticed that "Modify" button (located next to "Add") button is grayed out. I suspect that this will actually help me with my question #1, but I don't know how to access this. Can someone help me? Really appreciate it! P.S. I really don't want to use macros or programs unless MS designed it and included it in the patch. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Access Toolbar questions
I only just noticed the lack of icons on some of these buttons.
Unfortunately, you cannot customise the QAT through code without removing and rebuilding the entire ribbon as well, so the steps may not be worth it. I will try and find out a little more information -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "3phoenix" wrote in message ... I just bought Office 2007, and I have two questions regarding Quick Access Toolbars. 1. I use Excel frequently, and I am taking advantage of the quick access toolbars (below the ribbon). Unfortunately, when you insert commads to QAT, command icons without pre-assigned graphic appear as "green dots", i.e. paste formula and paste value commands. Is there a way to change this - I don't know why MS do not provide tools to solve this proble, like custom icon designer. 2. Under the same heading, when I add command in "Customizing the QAT" section, I noticed that "Modify" button (located next to "Add") button is grayed out. I suspect that this will actually help me with my question #1, but I don't know how to access this. Can someone help me? Really appreciate it! P.S. I really don't want to use macros or programs unless MS designed it and included it in the patch. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Quick Access Toolbar Changes not Saved | Excel Discussion (Misc queries) | |||
quick access toolbar | Excel Discussion (Misc queries) | |||
Extremely frusterated. 3 quick questions | Excel Worksheet Functions | |||
Grouping of icons in the Quick Access Toolbar... Excel 2007 | Excel Discussion (Misc queries) | |||
two quick questions on excel. please answer as soon as possible... | Excel Worksheet Functions |