Can't display code

sheila_d_pratt · 03-07-2005, 11:06 AM

Hi,

When I go back to my file, I can't see the code that I've written. I know
it's still there, because the workbook will execute properly. I go to the
code view and still can't see it. I'm new to VBA, so I must be missing
something very obvious.

Thanks
--
sheila

Don Guillett · 03-07-2005, 11:06 AM

a private module or a private sub can't be viewed.

--
Don Guillett
SalesAid Software
donaldb@281.com
"sheila_d_pratt" <sheiladpratt@discussions.microsoft.com> wrote in message
news:99542B35-BC92-443D-B3A5-E6D2BB4C93F2@microsoft.com...
> Hi,
>
> When I go back to my file, I can't see the code that I've written. I know
> it's still there, because the workbook will execute properly. I go to the
> code view and still can't see it. I'm new to VBA, so I must be missing
> something very obvious.
>
> Thanks
> --
> sheila

**Norie** · 03-07-2005, 11:39 AM

How are you trying to view the code?

Try ALT+F11 to open the VBA editor and check all the modules in the Project Explorer.

sheila_d_pratt · 03-07-2005, 12:06 PM

Thanks Don, but how do I change or delete the code if it can't be viewed?

Sheila

"Don Guillett" wrote:

> a private module or a private sub can't be viewed.
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "sheila_d_pratt" <sheiladpratt@discussions.microsoft.com> wrote in message
> news:99542B35-BC92-443D-B3A5-E6D2BB4C93F2@microsoft.com...
> > Hi,
> >
> > When I go back to my file, I can't see the code that I've written. I know
> > it's still there, because the workbook will execute properly. I go to the
> > code view and still can't see it. I'm new to VBA, so I must be missing
> > something very obvious.
> >
> > Thanks
> > --
> > sheila
>
>
>

**AlfD** · 03-07-2005, 12:32 PM

Hi!

Can you remember a word or range or something in your code?
If so, use Find from any of the code modules, checking Current Project.
Should find it.

If not: can you tell us how you wrote your code? How did you get to a module to do it? Anything you did thereafter...

Alf

Don Guillett · 03-07-2005, 04:10 PM

try alt f11

--
Don Guillett
SalesAid Software
donaldb@281.com
"sheila_d_pratt" <sheiladpratt@discussions.microsoft.com> wrote in message
news:329CA565-C249-4E7E-866D-748CCE17DAD1@microsoft.com...
> Thanks Don, but how do I change or delete the code if it can't be viewed?
>
> Sheila
>
> "Don Guillett" wrote:
>
> > a private module or a private sub can't be viewed.
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "sheila_d_pratt" <sheiladpratt@discussions.microsoft.com> wrote in
message
> > news:99542B35-BC92-443D-B3A5-E6D2BB4C93F2@microsoft.com...
> > > Hi,
> > >
> > > When I go back to my file, I can't see the code that I've written. I
know
> > > it's still there, because the workbook will execute properly. I go to
the
> > > code view and still can't see it. I'm new to VBA, so I must be
missing
> > > something very obvious.
> > >
> > > Thanks
> > > --
> > > sheila
> >
> >
> >