View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Customizing menu buttons in Ecel 2007

Hi Lorne,

See if this helps:

You can customize the Quick Access Toolbar (QAT for short) and insert
buttons to run macros either for all workbooks or for specified workbooks.
(specified workbooks need to be open)

Open the workbook for which you want the buttons

Right click a blank section of QAT

Select Customize QAT

Click dropdown arrow on field titled: €śChoose commands from€ť

Select macros

Click drop down arrow on field titled: €śCustomize Quick Access Toolbar€ť

Select the workbook for which you want the buttons

Select the macro form the list (Will have to search down the list because
all the internal macros are there also)

Click Add

Click the Modify button towards bottom right

Select a button design. (I think this is what you wanted)

Note that you can select any of the added buttons and use the Up/Down arrows
at the right to position them. There is also a separator that can be selected
at the top of the macro list.

Regards,

OssieMac


"Lorne" wrote:

I have just upgraded from Excel 2003 and have several custom buttons in my
menu that execute macros. In v2003 I could copy a suitable image to the
menu button but that feature seems to be lost in v2007.

How can I customize the image that appears on my buttons?