Thank you for the example, really helped to clarify what the others where
saying, I am very new to programming and greatly appreciate the assistiance.

"Harald Staff" wrote:

Hi keven

Adding to the others a small sample. Macros can /should be in separate
modules:

Sub Auto_open()
Call PartOne
Call PartTwo
Call PartThree("Tada !")
End Sub

Sub PartOne()
MsgBox "Hi"
End Sub

Sub PartTwo()
MsgBox "Bye"
End Sub

Sub PartThree(strMsg As String)
MsgBox strMsg
End Sub

HTH. Best wishes Harald

"Keven Swingle" skrev i melding
...
I am gettting the following error when trying to compile my excel macro.
"COMPILE ERROR: PROCEDURE TOO LARGE"
How do I get around this error message and allow excel to compile my
auto_open macro?

Thanks in advance.
Keven