Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

ResolvedVersion 2003

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

Eliska has attended:
Excel Intermediate course
Excel Advanced course

Macros

how do you work with visual basic editor?

Mon 21 Jul 2008, 11:25 Trainer 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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Macros

Macros

RE: macros

Excel articles

Excel tip:

Sorting List Subtotals