module not accessable
 

Morning all.
I'm trying to open a module in the VBE, and it's not allowing me to view it.
I can view all the other modules. I don't have an active macro running. There
is no password protection on the module/file, so that's not it. I click F7,
and nothing happens. I click ctrl+f and the window comes up, and shows each
line where I'm finding the searched for element, but does not open the module
for viewing the contents.

What would prevent a module from being viewable?
Help! Please....

module not accessable
 

Steve-

Is the module one that you created? If not, what is the name of the module?

If it is an add-in (or a native Excel module) then even though it is visible
in the VBE when you are working on your own workbook, it is probably still
password protected by whomever created it, to protect their intellectual
property.

"Steve" wrote:

Morning all.
I'm trying to open a module in the VBE, and it's not allowing me to view it.
I can view all the other modules. I don't have an active macro running. There
is no password protection on the module/file, so that's not it. I click F7,
and nothing happens. I click ctrl+f and the window comes up, and shows each
line where I'm finding the searched for element, but does not open the module
for viewing the contents.

What would prevent a module from being viewable?
Help! Please....

module not accessable
 

Hi Ker,

This module of one of my own creation.

Moreover, password protected modules always give warning, or ask for a
password when protected. This did not happen. It simply did not appear for
viewing.

This module is in fact in an addin-- *.xlam file that I created about 3
months after we got 2007 installed-- back in summer of 2007.

I can however access all other modules in that xlam file. It's only that one
module that's not appearing.

Thanks for your responsiveness, and helps- they're appreciated.


"ker_01" wrote:

Steve-

Is the module one that you created? If not, what is the name of the module?

If it is an add-in (or a native Excel module) then even though it is visible
in the VBE when you are working on your own workbook, it is probably still
password protected by whomever created it, to protect their intellectual
property.

"Steve" wrote:

Morning all.
I'm trying to open a module in the VBE, and it's not allowing me to view it.
I can view all the other modules. I don't have an active macro running. There
is no password protection on the module/file, so that's not it. I click F7,
and nothing happens. I click ctrl+f and the window comes up, and shows each
line where I'm finding the searched for element, but does not open the module
for viewing the contents.

What would prevent a module from being viewable?
Help! Please....