P
pallaver
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
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