View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.