How do you view an active macro code?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a macro code on one of my worksheets, but can't seem to find out how
to open it in VBE to edit it.

Seems like a simple resolution, but I can't for the life of me get the
existing code to display, but I know it's there.

Thanks.
 
Alt+F11

then in turn double click the worksheets and 'ThisWorkbook' until you find it
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Mike,
I know how to load VBE, however, still can't find and view the existing
code. I know which worksheet it's on. Maybe I'm not understanding your
response.

I'm running 2003.
 
In Excel window.

Right-click on the worksheet tab and "View Code"

Anything there?


Gord Dibben MS Excel MVP
 
I know that much. That launches VBE. Loads a new window to enter code,
however there's one already there, but does not display! Nor can I find a
way to find it.
 
Back
Top