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

Resolved · Low Priority · Version Standard

Phil has attended:
Access Introduction course

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

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	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) Reply

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

· 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