How do you view an active macro code?
 

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.

How do you view an active macro code?
 

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.


"Scott" wrote:

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.

How do you view an active macro code?
 

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.



"Mike H" wrote:

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.


"Scott" wrote:

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.

How do you view an active macro code?
 

In Excel window.

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

Anything there?


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 09:36:03 -0800, Scott
wrote:

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.



"Mike H" wrote:

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.


"Scott" wrote:

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.

How do you view an active macro code?
 

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.





"Gord Dibben" wrote:

In Excel window.

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

Anything there?


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 09:36:03 -0800, Scott
wrote:

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.



"Mike H" wrote:

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.


"Scott" wrote:

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.

.