excel consultant

excel consultant - Macro

Resolved · Low Priority · Version Standard

Macro

Carrie has attended:
Excel Advanced course

by - delegate Carrie [1 post] (2007 Feb 7 Wed, 09:48) Reply

How do I edit a macro

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macro

by - trainer Amanda diamond contributer [1217 posts] (2007 Feb 7 Wed, 09:59) Reply

Hi Carrie

Thanks for posting to our forum.

You can edit a macro by going to Tools - Macro - Macros, selecting the macro you wish to edit and clicking the Edit button.

This will open a Visual Basic window where you can edit the macro and save the changes you have made.

Enjoy your training today
Amanda

· How to Create Better Excel Spreadsheets: Part Three
· Interesting Lifestyle Applications for Microsoft Excel
· Advanced Excel Training - takes you to the next level
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· How to check for and reduce errors in Microsoft Excel

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips

Rate this page: