Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Sub Workbook_Open() doesn't run | Excel Discussion (Misc queries) | |||
Private sub problem | Excel Worksheet Functions | |||
Private Sub CommandButton1_Click() | Excel Discussion (Misc queries) | |||
Common Private Sub | Excel Discussion (Misc queries) | |||
Private sub | New Users to Excel |