| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need VBA Code to Let User Define Active Sheet | Excel Discussion (Misc queries) | |||
| What is the code for the active worksheet? | Excel Discussion (Misc queries) | |||
| How to Add Rows From Active Cell with in a XLL Code | Excel Worksheet Functions | |||
| keep active sheet view and cursor position | Excel Worksheet Functions | |||
| is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
Hybrid Mode
