Macro

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

Resolved · Low Priority · Version 2003

Macro

Monique has attended:
Excel Advanced course

by - delegate Monique [1 post] (2008 Apr 16 Wed, 16:35) Reply

How do I insert a picture to use as the macro button?

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: Macro

by - trainer Pete platinum contributer [795 posts] (2008 Apr 17 Thu, 08:59) Reply

Hi Monique, Thank you for your post, welcome to the forum in answer to your question, use the Insert>Picture, operation to insert your chosen graphic, resize it from the corner handles, and then right click on it, choose the option Assign Macro, from the dialog box that opens select the macro you wish to run and click OK, Clicking on your grahic/picture will now run your macro. I hope that has helped, best regards Pete.

· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Database Tips from an Excel Training Course
· How to Create Better Excel Spreadsheets: Part Four
· Compare Different MS Excel Training Methods
· Features of Microsoft Excel that assist in Analysis of Financial Data

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Shortcuts for working with named ranges in Excel

If you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful.

- Bring up the Define Names dialogue box on screen by using Ctrl + F3 (instead of going to Insert - Names).

- Create Names from labels you have entered into the spreadsheet by highlighting the labels and related figures, then hold down Shift + Ctrl + F3. You can then choose to create names from the top or bottom rows, or left or right columns.

- Go directly to a named range by hitting the F5 key. The Go To dialogue box will open and display any named ranges in the spreadsheet. Simply select the named range to navigate to it in the spreadsheet.

View all Excel hints and tips