How do I create a custom button that combines format settings?

P

PhillipB

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.
 
P

PhillipB

Hi Pecoflyer,

I neglected to mention that I'm using Excel 2007. Sorry. My bad. Anyway, I
still need the solution, just geared for Excel 2007.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I save a custom cell format that I created? 1
How do I create a custom button to assign to a Word macro? 2
How do I create a custom print button? 3
How do I create a custom button in PowerPoint? 1
How do I create a Formula bar toggle button 3
How do I create a custom number format in Excel using a symbol? 2
How Do I Assign a Toolbar Button to a Custom Number Format I creat 3
How do I assign a toolbar button to a custom number format I creat 1

Top