Solved

Can't view Excel Macro Code using Alt-F11

Posted on 2012-03-15
5
438 Views
Last Modified: 2012-03-15
This is a strange one.  I am using Excel 2003, the OS is XP, and I've recorded a Macro without any problem.  I can also run it without any problem.

My issue is that I can't view the code.  The Macro ought to be viewable under Module1 but the Immediate pane on the right is blank.

Any help would be appreciated.
0
Comment
Question by:esemmoc
5 Comments
 
LVL 12

Expert Comment

by:kgerb
ID: 37726577
hmmm...Are you saving the macro to your personal macro workbook?  Open the project explorer (Ctrl+r) and see if there are any other projects loaded where the macro might be stored.

Kyle
0
 
LVL 8

Expert Comment

by:2toria
ID: 37726579
Hi there.

Can you take a screenshot of what you see in the IDE and post it on here?  Might help diagnose the problem

Matt
0
 
LVL 12

Accepted Solution

by:
kgerb earned 350 total points
ID: 37726594
BTW, the immediate pane doesn't really have anything to do with your recorded macro.  The immediate window is used for running individual lines of code outside a subroutine.  It is also used for debugging but not for recorded macros.

Do you have the immediate window so large that it's covering up your code in the general code pane?

Kyle
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 37726619
Can you see the code when you do Tools|Macro|Macros|Edit|<select your macro>|Edit ?
0
 

Author Closing Comment

by:esemmoc
ID: 37726715
Yes, somehow the immediate pane was selected and I never realized that it was covering up the General pane.  When I closed it the General pane was visible.  

This affected any navigation that was intended to list out code e.g.   Tools --> Macros --> Step Into.

Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now