I am trying to make all my subs private to minimize confusion for
others using my excel spreadsheet.

All of my subs/macro are on Module1, including a public sub called
ItemDataInput.

On my Userform code, if the user presses a certain button it calls sub
ItemDataInput.

The problem though is if I make Sub ItemDataInput "Private", it
doesn't work.

Any way to work around this? Or do I have to just have a visible/
public sub? (This isn't the end of the world, could just have it be
public, but figured to ask :))

Thankx, NP

Keep the subs public, and add the statement

Option Private Module

to the start of Module1. This will make all procedures in Module1 public to
that project, but not to others, and they will not show in the macro list.

--
__________________________________
HTH

Bob

"pallaver" wrote in message
...
I am trying to make all my subs private to minimize confusion for
others using my excel spreadsheet.

All of my subs/macro are on Module1, including a public sub called
ItemDataInput.

On my Userform code, if the user presses a certain button it calls sub
ItemDataInput.

The problem though is if I make Sub ItemDataInput "Private", it
doesn't work.

Any way to work around this? Or do I have to just have a visible/
public sub? (This isn't the end of the world, could just have it be
public, but figured to ask :))

Thankx, NP

Excellent. Works like a charm. Now all those confusing sub routines
are all hidden gems for the weary to work their way through if they so
choose to, hehe.

Thanks for the tip, I was wondering what the point of the "Option
Explicit" was whenever you opened up a module using record macro.

On 7$B7n(B14$BF|(B, $B8a8e(B4:35, "Bob Phillips" wrote:
Keep the subs public, and add the statement

Option Private Module

to the start of Module1. This will make all procedures in Module1 public to
that project, but not to others, and they will not show in the macro list.

--
__________________________________
HTH

Bob

"pallaver" wrote in message

...



I am trying to make all my subs private to minimize confusion for
others using my excel spreadsheet.

All of my subs/macro are on Module1, including a public sub called
ItemDataInput.

On my Userform code, if the user presses a certain button it calls sub
ItemDataInput.

The problem though is if I make Sub ItemDataInput "Private", it
doesn't work.

Any way to work around this? Or do I have to just have a visible/
public sub? (This isn't the end of the world, could just have it be
public, but figured to ask :))

Thankx, NP- $B0zMQ%F%-%9%H$rI=<($7$J$$(B -

- $B0zMQ%F%-%9%H$rI=<((B -

I missed the relevance of your response.

--
__________________________________
HTH

Bob

"pallaver" wrote in message
...
I am trying to make all my subs private to minimize confusion for
others using my excel spreadsheet.

All of my subs/macro are on Module1, including a public sub called
ItemDataInput.

On my Userform code, if the user presses a certain button it calls sub
ItemDataInput.

The problem though is if I make Sub ItemDataInput "Private", it
doesn't work.

Any way to work around this? Or do I have to just have a visible/
public sub? (This isn't the end of the world, could just have it be
public, but figured to ask :))

Thankx, NP