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

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?

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?
.