Solved

Can't view Excel Macro Code using Alt-F11

Posted on 2012-03-15
5
426 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
Comment Utility
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
Comment Utility
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
Comment Utility
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 45

Expert Comment

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

Author Closing Comment

by:esemmoc
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Excel - Scroll Speed 3 24
Splitting out Data 14 27
Excel 2016 Hiding Toolbars 7 14
Formula to convert ranked data 2 6
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

771 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

10 Experts available now in Live!

Get 1:1 Help Now