Custom buttons

[Francis Hookham]

XL 2004

No facility for editing toolbar buttons in 2004 which is serious since I
have many shortcut macros run by toolbar buttons!

Was ok previous versions of Mac and PC XL

Any suggestions, apart from going back in Classic and copying from earlier
version and pasting in from there which is tedious and does not seem to
reproduce well

(Same prob with Word 2004!)

Another grumble is not being able to right click on the toolbar to get to
Customise which now has three choices! Seems to be all retrograde

Francis Hookham

 

[Bob Greenblatt]

XL 2004

No facility for editing toolbar buttons in 2004 which is serious since I have
many shortcut macros run by toolbar buttons!

Was ok previous versions of Mac and PC XL

Any suggestions, apart from going back in Classic and copying from earlier
version and pasting in from there which is tedious and does not seem to
reproduce well

(Same prob with Word 2004!)

Another grumble is not being able to right click on the toolbar to get to
Customise which now has three choices! Seems to be all retrograde

Francis Hookham

Are you talking about editing the button face, or simply adding/changing
assigned macros. If the later, it certainly works in excel 2004. You can
customize toolbars by view-toolbars-customize.

 

[JE McGimpsey]

No facility for editing toolbar buttons in 2004 which is serious since I
have many shortcut macros run by toolbar buttons!

Was ok previous versions of Mac and PC XL

If you're talking about the button faces, MacBU got rid of the
antiquated button editor after Office 2001.

Any suggestions, apart from going back in Classic and copying from earlier
version and pasting in from there which is tedious and does not seem to
reproduce well

(Same prob with Word 2004!)

Office v.X and 2004 allows you to use any 3rd party image editor. You
can create a 16 x 16 image in any graphics app, then paste it onto the
button (Tools/Customize Toolbars/Menus..., CTRL-click the button, choose
Properties, then select Paste Button Image from the button dropdown).
Native FaceIDs are 20 x 20 pixels, and Help says you can use 20 x 20 in
your custom icons, but you can't.

Or you can take a gif/jpg/png, and paste it onto the face, and XL will
scale it.

Another grumble is not being able to right click on the toolbar to get to
Customise which now has three choices! Seems to be all retrograde

You can right-click any group separator and choose Customize
Toolbars/Menus... (and it's the only choice).

 

[Francis Hookham]

Many thanks JE ­ I shall try the 16x16 paste in but...

How can I introduce a group separator into one the custom toolbars ­ I
abandoned the space wasting overloaded default toolbars years ago ­ for the
moment I have contrived to copy the Customize Toolbars/Menus button from the
Customize dropdown and added a smiley face having beaten the system until it
catches me out the next time!

(Bob ­ sorry ­ I should have made the query clearer ­ it is button face I am
interested in)


If you're talking about the button faces, MacBU got rid of the
antiquated button editor after Office 2001.


Office v.X and 2004 allows you to use any 3rd party image editor. You
can create a 16 x 16 image in any graphics app, then paste it onto the
button (Tools/Customize Toolbars/Menus..., CTRL-click the button, choose
Properties, then select Paste Button Image from the button dropdown).
Native FaceIDs are 20 x 20 pixels, and Help says you can use 20 x 20 in
your custom icons, but you can't.

Or you can take a gif/jpg/png, and paste it onto the face, and XL will
scale it.

You can right-click any group separator and choose Customize
Toolbars/Menus... (and it's the only choice).[/QUOTE]

 

[JE McGimpsey]

How can I introduce a group separator into one the custom toolbars ­ I
abandoned the space wasting overloaded default toolbars years ago ­ for the
moment I have contrived to copy the Customize Toolbars/Menus button from the
Customize dropdown and added a smiley face having beaten the system until it
catches me out the next time!

Tools/Customize Toolbars/Menus..., right- or CTRL-click on the button,
choose Properties from the popup menu. In the Command Properties dialog,
check the "Begin a group" checkbox.