excel custom buttons
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel custom buttons

Excel custom buttons

The UK's most regular instructor-led training courses.
Training information: excel-training-advanced courses · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

resolvedResolved · Low Priority · Version Standard

Excel custom buttons

Phil has attended:
Access Introduction course

by - delegate Phil [1 post] (2008 Mar 6 Thu, 09:36) replyReply

I want to add a button on my toolbar that has a customised cell formatting for Millions, with brackets etc. I have the format, but am struggling to see how to add this to the toolbar.
Any help greatfully appreciated
thanks

Excel Intermediate 1 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2003/XP 2008 Aug 21 Thu Bloomsbury 0 FULL    
2003/XP 2008 Aug 21 Thu Bayswater 2 book now £195 £205
2003/XP 2008 Aug 28 Thu Southwark 1 book now £215 £215
2003/XP 2008 Aug 29 Fri Tooting 0 FULL    
2003/XP 2008 Sep 2 Tue Bloomsbury 5 book now £198 £215
2003/XP 2008 Sep 4 Thu Bayswater 5 book now £195 £205
Full Schedule: See all 141 Excel Intermediate course dates.
Bookings currently available until 25th November 2009.

RE: Excel custom buttons

by - trainer Mara silver contributer[73 posts] (2008 Mar 9 Sun, 19:19) replyReply

Hello Phil,
I hope you enjoyed your Access training session with us.

In response to your question, since you have created this format yourself, it will not be available as a selectable custom button option. However, you could record a macro that changes the value in the cell to this format, and then add the macro to a custom button.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer


Related articles

· How to Create Better Excel Spreadsheets: Part Three
· Customized Financial Excel Courses in London
· A Beginners Guide To Formulas In Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Please browse our web site to find out more about
excel-training-advanced courses and other Microsoft training courses.

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information
AddThis Social Bookmark Button What's this?
Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo Add to Diigo Add to Mr. Wong Add to Linkarena Add to Power Oldie Add to Folkd Add to Jumptags Add to Upchuckr Add to Simpy Add to StumbleUpon Add to Slashdot Add to Netscape Add to Furl Add to Spurl Add to Blinklist Add to Blogmarks Add to Technorati Add to Newsvine Add to Blinkbits Add to Ma.Gnolia Add to Smarking Add to Netvouz