Yes. Just select the module and change its name in the properties window.
Just for fun if you would like a VBA solution here is a little one liner, guess could expand on this idea maybe, add this code to a standard module, and attach a forms command button. Edit to site.
Sub myRenameA ()
ActiveWorkbook.VBProject.VBComponents("Module1").Name = _
That one might bug so try this, you must add to trusted sources also forgot that bit opps !!!
On Error Resume Next
.VBComponents("Module1").Name = "NewX"
On error goto 0
‘ some code
Derk, read your note on changing a module name, however, when I change Module1 to AddComments and then save , when the macro runs I get a box saying that the -Originally Posted by Derk
test.xls!AddComments macro cannot be found. I have to rename it back to Module 1
Norrie, the macro is called AddComments, part code below-
' Comments Macro
' Macro recorded 30/10/2004 by Colin Johnston ACC
' As before, copy and paste to add new codes
' Insets Tel Nos.Comment
Range("B1").Comment.Visible = False
Range("B1").Comment.Text Text:="Colin Johnston ACC:" & Chr(10) & ""
Range("B1").Comment.Text Text:= _
"Red Marks at Top Corner of Cells Indicate a Telephone Number, Hover Mouse over Cell to Reveal" _
& Chr(10) & ""
The macro is in Test.xls in module2, when I try to rename Module 2 to something else I get the error
It looks like you are trying to call the Module the same name as the Procedure, which should not be done.
Oh dear I need a beer
Online Motorsport Game
There are currently 1 users browsing this thread. (0 members and 1 guests)