| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| new window hide column problem | Excel Discussion (Misc queries) | |||
| Public Macro Help (CFColorindex) | Excel Worksheet Functions | |||
| Practical use of Window Hide | Excel Programming | |||
| How to hide Excel window when activating a Shape object | Excel Programming | |||
| Creating Event procedures from a macro | Excel Programming | |||
Linear Mode
