microsoft+excel+course - macros
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - Macros

microsoft+excel+course - Macros

resolvedResolved · Low Priority · Version Standard

replyReply Fri 21 Dec 2007, 16:58Delegate Richard said...

Richard has attended:
Excel Advanced course
Access Introduction course

Macros

we are told not to click the x on the macro button. What happens if we did this?

For upcoming training course dates see: Pricing & availability

replyReply Wed 2 Jan 2008, 09:34Trainer Pete said...

RE: macros

Hi Richard, Thank you for your post, I hope you have enjoyed the Holiday season, in answer to your question:
If during recording you click on the X button to close the Stop Recording toolbar, you do not Stop Recording the macro, all you have done is close the Toolbar, and this has become a part of your recording. You then have to stop recording by following the options Tools, Macro, Stop Recording. However the next time you wish to record a macro the macro toolbar will not appear automatically, causing you to have to open it from the View, Toolbars menu command, also being recorded as part of your macro, this will cause your macro to run incorrectly or fail. I hope that helps, best regards Pete

 

Excel tip:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard