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

Break the procedure in to two or more smaller procedures,
passing, if necessary, variables from one procedure to the next.
Good structured programming techniques would already lead you
down this path.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Keven Swingle" wrote in
message
...
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

break up your code into more than one module.

--
Regards,
Tom Ogilvy

"Keven Swingle" wrote in message
...
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

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

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