title: How can I rename a module using VBA macro?
body: <p>I put one button on sheet. I want to assign macro for that button which change the module name.</p>
  
  <p>For e.g. There are two modules named <code>Module1</code> and <code>Module2</code>. So I want to replace module name of above two modules with each other. Can anyone suggest me how to rename a module using macro?</p>