ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Quick Access Toolbar questions (https://www.excelbanter.com/excel-discussion-misc-queries/139985-quick-access-toolbar-questions.html)

3phoenix

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.


Nick Hodge

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.




All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com