Does anyone have code to rename the modules

brettvba · Feb 21st, 2002, 01:04 PM

That would be so handy instead of calling it module1 call it a name any Ideas??

Tim Francis-Wright · Feb 21st, 2002, 01:54 PM

In the Project Explorer, you can select any module, then hit F4 to pull up the (single-entried) properties box. This lets you change the name manually.

Or you can do something like
ActiveWorkbook.VBProject.VBComponents("Module1").Name = "xyzzy"

(You can also use objects like
ActiveWorkbook.VBProject.VBComponents("Module1").CodeModule to do all sorts of wacky dynamic things to your VBA code.)

Feb 21st, 2002, 01:54 PM	#2
Tim Francis-Wright Board Regular Join Date: Feb 2002 Posts: 74	In the Project Explorer, you can select any module, then hit F4 to pull up the (single-entried) properties box. This lets you change the name manually. Or you can do something like ActiveWorkbook.VBProject.VBComponents("Module1").Name = "xyzzy" (You can also use objects like ActiveWorkbook.VBProject.VBComponents("Module1").CodeModule to do all sorts of wacky dynamic things to your VBA code.) __________________ "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 01:04 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	That would be so handy instead of calling it module1 call it a name any Ideas??