ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Rename a sub (https://www.excelbanter.com/excel-programming/272030-rename-sub.html)

ArthurJ[_2_]

Rename a sub
 
When I rename a sub in the VB editor, why doesn't it show
up in the macro list?

Chip Pearson

Rename a sub
 
If the procedure takes arguments, it will not show up in the macro
list. Does your procedure take arguments?


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


"ArthurJ" wrote in message
...
When I rename a sub in the VB editor, why doesn't it show
up in the macro list?




andres

Rename a sub
 
See if you have the Option Private Module at the beggining
of the module.
this will not allow the new sub to show up

Andres


-----Original Message-----
When I rename a sub in the VB editor, why doesn't it show
up in the macro list?
.



All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com