Excel 2000 Macro

[Guest]

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

 

[Chip Pearson]

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

message
news:[email protected]...

 

[Tom Ogilvy]

break up your code into more than one module.

 

[Harald Staff]

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

 

[Guest]

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.