MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

viewing macro code

  Asked By: Chigaru    Date: Jan 04    Category: MS Office    Views: 1706

I'm looking at a workbook that says it contains macros. I don't want
to run them until I see the code behind them, but when I open the
workbook and go to Tools/Macro/Macros, there are no macro names
listed in the dialogue box, nor do I see any code in the Visual Basic
Editor. Am I looking in the wrong place?



2 Answers Found

Answer #1    Answered By: Katrina Edwards     Answered On: Jan 04

When you open  VBA, there should be a window on the left marked “Project …”

To see the code, you will have to select (dbl-click) one of the entries in that window. For example, the entry could say “ThisWorkbook”

Answer #2    Answered By: Eddie Austin     Answered On: Jan 04

You must go one step further. Select the Visual Basic Editor in
that sub menu.

Didn't find what you were looking for? Find more on viewing macro code Or get search suggestion and latest updates.