call module on startup

T

theintern

i have this project running a macro every time it's opened. the problem is
that now i want to run that same module, but pass a variable to it. it's
giving me various errors, depending on how i code it, but nothing seems to be
working. Please help! I have to present this tomorrow!

scott

Private Sub Project_Open(ByVal pj As Project)
Dim stayopen As Integer
stayopen = 1
ImportAll (stayopen)
End Sub

Sub ImportAll(stayopen As Integer)
....
end sub
 
T

theintern

I found a way around it by creating a macro which calls the module, so now i
dont' have to pass any variables from the project module. thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top