Forum Discussion
Tommee
Jun 21, 2023Copper Contributor
Called sub macro disappears after adding ByRef or ByVal variables and exiting out
Hello. I need help with a disappearing called sub macro. If I create a new sub macro called AccountDesc with nothing in it, & edit it in my macro list it looks like this: Sub AccountDesc() ‘ Comme...
HansVogelaar
Jun 21, 2023MVP
A macro is a procedure (sub) without any arguments. The moment you add an argument to a procedure, it is not a macro anymore, so it is no longer listed in the Macros dialog.
You can still view and edit it in the Visual Basic Editor.
Tommee
Jun 21, 2023Copper Contributor
OK. I didn't know that. I'll look for it in the VB Editor. Thank you.