Hide public procedures in macro window?
 

Have several public procedures in my vba code that are showing up in the
macro display/selection dialog.

Is there a way to hide them from the workbook users?

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

Hide public procedures in macro window?
 

Give them an optional argument even if you don't use it.

--
Regards,
Tom Ogilvy

"What-a-Tool" wrote in message
news:3tG0d.12079$OZ6.5315@okepread06...
Have several public procedures in my vba code that are showing up in the
macro display/selection dialog.

Is there a way to hide them from the workbook users?

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

Hide public procedures in macro window?
 

Thanks again!

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

"Tom Ogilvy" wrote in message
...
Give them an optional argument even if you don't use it.

--
Regards,
Tom Ogilvy

"What-a-Tool" wrote in message
news:3tG0d.12079$OZ6.5315@okepread06...
Have several public procedures in my vba code that are showing up in the
macro display/selection dialog.

Is there a way to hide them from the workbook users?

--

/ Sean the Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)