View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PhillipB PhillipB is offline
external usenet poster
 
Posts: 2
Default How do I create a custom button that combines format settings?

In our business we often use the "Accounting" dollar sign ($) format setting
(with no decimals) along with the double-underline setting. Rather than
sellect the individual buttons each time, we'd like one button that combines
these format settings. Once it is created, I need to be able to 'distribute'
it to other users.

If one of you is really ambitious, in addition to the above, here are some
other custom formats and buttons that we need:

1) An "Accounting" style underline (accross the whole cell - but NOT a cell
border)

2) A "dash" place-holder that appears in the 'hundred' spot

Thanks in advance.