View Single Post
  #3  
Old April 28th, 2008, 02:46 PM posted to microsoft.public.excel.setup
shieber
external usenet poster
 
Posts: 6
Default Customizing Menus and Quick Access Toolbar in 2007

How, can one edit icons. You can choose among a list of ready-made ones for
existing commands but there seems to be no way to edit or create an image for
any new command(macro) you attach. It's almost like working in Macworld,
where Apple decides what you do and don't need.

"Mags" wrote:

Click on ‘Cusomize Quick Access Toolbar’
Then ‘More commands’
In the dialog that opens, drop down the ‘Choose commands from’ menu and
select ‘Macros’
Your macro should be visible in the left hand pane.
Add it to your Quick Access Toolbar, then you can modify the icon if you want.
Hope this helps

"Loris" wrote:

In Excel 2003 I was able to add a menu and then add macros to it. I was also
able to add macros to custom buttons to any toolbar. In 2007 I can create a
custom button within a workbook to which I can add a macro, but how do I add
it to the ribbon bar? How do I add a button with a macro assigned to it to
the Quick Access Toolbar? Incidentally, I'm still using Windows XP. Thanks