Rename Module
 

Within Excel's Visual Basic Editor, how can you rename modules with the
project. I only see the ability to Remove, not to Rename.

Rename Module
 

Select the module, make sure that the Properties window is active, and you
can change the name there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"djh" wrote in message
...
Within Excel's Visual Basic Editor, how can you rename modules with the
project. I only see the ability to Remove, not to Rename.

Rename Module
 

select the modulef4change

--
Don Guillett
SalesAid Software

"djh" wrote in message
...
Within Excel's Visual Basic Editor, how can you rename modules with the
project. I only see the ability to Remove, not to Rename.

Rename Module
 

Thanks, I stumbled upon the Properties button so found it. If I rename and
organize my modules, how can I call a sub from one module that is stored in
another module? How do I make the sub available?

"Bob Phillips" wrote:

Select the module, make sure that the Properties window is active, and you
can change the name there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"djh" wrote in message
...
Within Excel's Visual Basic Editor, how can you rename modules with the
project. I only see the ability to Remove, not to Rename.

Rename Module
 

Procedures in one module can be directly accessed by a procedure
in another module, unless that procedure is declared as Private.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"djh" wrote in message
...
Thanks, I stumbled upon the Properties button so found it. If
I rename and
organize my modules, how can I call a sub from one module that
is stored in
another module? How do I make the sub available?

"Bob Phillips" wrote:

Select the module, make sure that the Properties window is
active, and you
can change the name there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"djh" wrote in message
...
Within Excel's Visual Basic Editor, how can you rename
modules with the
project. I only see the ability to Remove, not to Rename.

Rename Module
 

The error I got was the result of renaming the module to the same name as the
sub.

"Chip Pearson" wrote:

Procedures in one module can be directly accessed by a procedure
in another module, unless that procedure is declared as Private.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"djh" wrote in message
...
Thanks, I stumbled upon the Properties button so found it. If
I rename and
organize my modules, how can I call a sub from one module that
is stored in
another module? How do I make the sub available?

"Bob Phillips" wrote:

Select the module, make sure that the Properties window is
active, and you
can change the name there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"djh" wrote in message
...
Within Excel's Visual Basic Editor, how can you rename
modules with the
project. I only see the ability to Remove, not to Rename.

Rename Module
 

The error I got was the result of renaming the module to the
same name as the
sub.

Don't do that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"djh" wrote in message
...
The error I got was the result of renaming the module to the
same name as the
sub.

"Chip Pearson" wrote:

Procedures in one module can be directly accessed by a
procedure
in another module, unless that procedure is declared as
Private.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"djh" wrote in message
...
Thanks, I stumbled upon the Properties button so found it.
If
I rename and
organize my modules, how can I call a sub from one module
that
is stored in
another module? How do I make the sub available?

"Bob Phillips" wrote:

Select the module, make sure that the Properties window is
active, and you
can change the name there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"djh" wrote in message
...
Within Excel's Visual Basic Editor, how can you rename
modules with the
project. I only see the ability to Remove, not to
Rename.