Excel - Macros

Resolved · Low Priority · Version Standard

Excel - Macros

Tom has attended:
Excel Advanced course

by - delegate Tom [1 post] (2008 Feb 22 Fri, 16:38) Reply

I have recorded a macro but neglected to assign a shortcut key. I would now like to do this, is there something I can add to tne VBA coding to do this.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel - Macros

by - trainer Mara silver contributer [73 posts] (2008 Mar 2 Sun, 17:35) Reply

Hello Tom,
I hope you enjoyed your Excel training session with us.

To answer your question, it actually isn't even necessary to alter the VBA to change your keyboard shortcut on your macro. To create or edit the shortcut, go to Tools > Macro > Macros. Find the macro you want to assign the shortcut to, and click options. Here, you can change the shortcut.

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

· Microsoft Excel Courses Teach Advanced Macro Techniques
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· MS Excel: Excel At Making The Most Of Your Christmas

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

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Rate this page: