Rename Modules Using Macro

[Jaye7]

Is this a script that I can use to rename a module in my workbook.

i.e. I want to use a script to change

code:
private sub module1

to

code:
sub module1

And then when I am finished using it I would then change it back to private sub.

I don't want all the scripts in the macros dropdown list yet if I set them to private sub then they will not work.

Thanks

 

[pgc01]

Hi

I'd avoid changing code with code.

I don't want all the scripts in the macros dropdown list yet if I set them to private sub then they will not work.

If that's your problem, there are other alternatives, for ex.: declare the Subs that have no parameters (the only ones that appear in the macros list) as Functions, and they will not appear in the macros dropdown list.

 

[RoryA]

Use:

Option Private Module

at the top of the module whose subs you do not want to appear in the macros dialog.

 

[Jaye7]

Thanks Rorya, that works great, I appreciate your help.