VBA Module Names

Mar 14th, 2002, 05:56 PM

Is there a way to rename modules as they appear in the VBA editor i.e. Module1, Module2 etc.? I've looked everywhere I know of and also tried exporting it with a different name, but when I reinport it, it just assigns another number as the module name. Also, is there a way to insert a right aligned print footer to print in a color different from the left and center aligned footers?

John · Mar 14th, 2002, 06:05 PM

In the visual basic editor, press F4 the properties window will open. Select the module you want to rename and type the new name.

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

Mar 14th, 2002, 05:56 PM	#1
Guest Posts: n/a	Is there a way to rename modules as they appear in the VBA editor i.e. Module1, Module2 etc.? I've looked everywhere I know of and also tried exporting it with a different name, but when I reinport it, it just assigns another number as the module name. Also, is there a way to insert a right aligned print footer to print in a color different from the left and center aligned footers?

Mar 14th, 2002, 06:05 PM	#2
John New Member Join Date: Mar 2002 Location: New Zealand Posts: 24	In the visual basic editor, press F4 the properties window will open. Select the module you want to rename and type the new name.