Private - seeing macros again!
 

Hi,

Used the private string at the start of the macro to hide it from users. Of
course, now I can't see it and need to make a change. Any ideas as how I get
to see them again?

Thanks,

Nick

Private - seeing macros again!
 

Alt+F11 to get VBE
click on the module where your code is

HTH
--
AP

"Nick Smith" a écrit dans le message
de ...
Hi,

Used the private string at the start of the macro to hide it from users.
Of
course, now I can't see it and need to make a change. Any ideas as how I
get
to see them again?

Thanks,

Nick

Private - seeing macros again!
 

Tried everything I can think of in VBE to get them, but can't find them. How
do I find the list of modules to choose from? Sorry. First time with VB....

"Ardus Petus" wrote:

Alt+F11 to get VBE
click on the module where your code is

HTH
--
AP

"Nick Smith" a écrit dans le message
de ...
Hi,

Used the private string at the start of the macro to hide it from users.
Of
course, now I can't see it and need to make a change. Any ideas as how I
get
to see them again?

Thanks,

Nick

Private - seeing macros again!
 

Is the Project Explorer showing in the VBA editor? If not go to the View
menu and select it - that is where the modules are listed.

BTW: A Private Sub is not "hidden" from users, it is "hidden" from other
modules. That is, it can only be called by other subs/functions within the
same module. So it has nothing to do with keeping users from seeing it,
anyone who can get into VBA would still see it.
--
- K Dales


"Nick Smith" wrote:

Tried everything I can think of in VBE to get them, but can't find them. How
do I find the list of modules to choose from? Sorry. First time with VB....

"Ardus Petus" wrote:

Alt+F11 to get VBE
click on the module where your code is

HTH
--
AP

"Nick Smith" a écrit dans le message
de ...
Hi,

Used the private string at the start of the macro to hide it from users.
Of
course, now I can't see it and need to make a change. Any ideas as how I
get
to see them again?

Thanks,

Nick

Private - seeing macros again!
 

That's great. Thanks very much for your help.

"K Dales" wrote:

Is the Project Explorer showing in the VBA editor? If not go to the View
menu and select it - that is where the modules are listed.

BTW: A Private Sub is not "hidden" from users, it is "hidden" from other
modules. That is, it can only be called by other subs/functions within the
same module. So it has nothing to do with keeping users from seeing it,
anyone who can get into VBA would still see it.
--
- K Dales


"Nick Smith" wrote:

Tried everything I can think of in VBE to get them, but can't find them. How
do I find the list of modules to choose from? Sorry. First time with VB....

"Ardus Petus" wrote:

Alt+F11 to get VBE
click on the module where your code is

HTH
--
AP

"Nick Smith" a écrit dans le message
de ...
Hi,

Used the private string at the start of the macro to hide it from users.
Of
course, now I can't see it and need to make a change. Any ideas as how I
get
to see them again?

Thanks,

Nick