Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion Standard

Fern has attended:
Excel Advanced course
Excel Advanced course

Macros

how do you edit a macro

RE: macros

Dear Fern

Thank you for attending the Excel Advanced Course. I hope you enjoyed it.

You can access the Visual Basic Editor to make necessary changes for your current macro. Please bear in mind that this window expects you to have knowledge of VBA (Visual basic For Application) which is a programming language. You can do simple changes such as changing the name, changing the margins, or calculations in a formula quite simply but if you want to do more complicated editing then I would suggest you to attend our two day course to get in-depth knowledge and understanding of creating/editing macros.

Below is an example how you

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.