How to Change Excel VBA Module Name

To change the excel vba module name, from the tools menu go to Macro,
Choose Tools and go to Macros in the menu

From the dropdown select visual basic editor.
Select Visual Basic Editor (VBA)

Then select the module under the VBAProject which houses your filename.
Choose your VBA project

Right Click and select VBA Project Properties.

In Properties window, change the name as desired.

Changes will be saved when you click outside the box or click OK.
Click OK or anywhere outside the box

You’ve now now changed the Excel VBA module name.
VBA module name is now successfully changed

HowTech