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

advanced excel course

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel Course

Advanced Excel Course

ResolvedVersion 2003

Joanne has attended:
Excel Advanced course
Time Management course

Advanced Excel Course

How do you recover a macro if you've closed the visual basic editor window it's in and you can't find it?

RE: Advanced Excel Course

Hello Joanne,

Thank you for your question and welcome to the forum.

If you mean you are still in the Visual Basic Editor and have only closed the module window then,

On the left hand side of the screen you should see the Project - VBA Project window in which you will find the VBAProject.xls(PERSONAL.XLS) if you expand the + to the left of that you should see Mircosoft Excel Objects and Modules if you expand the + next to Modules you should find the Macro there and a double click should open the macro for you.

Thanks and Kind regards

Maggie

Excel tip:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

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.12 secs.