Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Renaming module (Excel 97/SR2/VBA)

    Is there a way to rename a module for an excel project?

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Renaming module (Excel 97/SR2/VBA)

    In the VBE, if they aren't already visible, display the properties window and project explorer. Click on the module you want to rename in the project explorer and in the properties window you should see the name of your module repeated twice - once with "module" after it and once with (Name) before it. Click on the one with (Name) before it and you can rename your module.

    Brooke

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Renaming module (Excel 97/SR2/VBA)

    Thanks for the response Brooke. After sleeping on this, I woke up and remembered the exact thing that you posted. Probably should be careful when it is past my bedtime. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •