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 » Macros

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Macros

resolvedResolved · Low Priority · Version 2003

replyReply Mon 30 Jun 2008, 16:40Delegate Eliska said...

Eliska has attended:
Excel Intermediate course
Excel Advanced course

Macros

how do you work with visual basic editor?

For upcoming training course dates see: Pricing & availability

replyReply Mon 21 Jul 2008, 11:25Trainer Pete said...

RE: macros

Hi Eliska,

Thank you for your post, in answer to your question, if you wish to edit a macro which has previously been recorded, follow these steps:

Note: Before undertaking any editing on essential objects you should ensure you are working on a copy of the original, this way should unforeseen errors occur you will not have corrupted your database.

1. Go to Start>Programs>Microsoft Excel to open the application. Go to File>New and open a new spreadsheet. Then go to Window>Unhide to bring the personal macro workbook forward

 

Excel articles

· Excel: Survival Of The Fittest
· Excel Charts As Easy As Pie
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to Create Better Excel Spreadsheets: Part One

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

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

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

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy