| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
| CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| can you rename a module? | Excel Discussion (Misc queries) | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
Linear Mode
