Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a custom button that combines format settings?
PhillipB;325408 Wrote: 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. Hi, select the cell you want to format Go to Tools Options - record Macro - Choose a name for the Macro - Ok Apply your formatting Stop the Macro recorder ( square button) Right click a Toolbar Select Customize Select Commands tab Select Macros under Categories Select a button and drag it to your toolbar Right Click the button Select Assign Macro Select the created macro Ok Now when you want to apply the fromat, click the cell to format Click your button Done -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90925 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a custom button that combines format settings?
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. "Pecoflyer" wrote: PhillipB;325408 Wrote: 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. Hi, select the cell you want to format Go to Tools Options - record Macro - Choose a name for the Macro - Ok Apply your formatting Stop the Macro recorder ( square button) Right click a Toolbar Select Customize Select Commands tab Select Macros under Categories Select a button and drag it to your toolbar Right Click the button Select Assign Macro Select the created macro Ok Now when you want to apply the fromat, click the cell to format Click your button Done -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90925 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a custom button in windows vista | New Users to Excel | |||
Button for custom number format | Setting up and Configuration of Excel | |||
New laptop - where are the custom button settings filed ? | Excel Discussion (Misc queries) | |||
Custom number format button | Excel Discussion (Misc queries) | |||
How do I create my own custom button? | Excel Discussion (Misc queries) |