Two Quickies

[Tom James]

1. How can I change the properties of a button on the Formatting toolbar? I
want to modify the currency style button so that when you click on it, it
will apply a currency formatting without decimals. The only way I know of
doing that is assigning it a macro. Is that the only way or is there a way
to access the properties of a Formatting button somehow?

2. Can the color of an active drop down control on an AutoFilter be changed?
For example, if you applied an AutoFilter on a list, and then apply a filter
on one of the columns, the down arrow will turn blue to indicate that it is
active. Is there any way to change the blue active drop down arrow to
another color?

Thanks!

Tom

 

[Dave Peterson]

#1. You have to assign a macro.
#2. There's no way that I know--or ever seen in the newsgroups.

 

[Tom James]

Dave,

Thanks for the response. You have confirmed my suspicions.

Tom