Ok...I have a macro I wrote which calls on other subs. I wanted to declare some global constants so I could change the variable easily if I had to change it later on. So this is what I have:

Sub MyMacro()

Public Const MATRIX As String = "Tab 1"
Public Const MATRIX2 As String = "Tab 2"

Call OtherSub
Call OtherSub2

End Sub

So basically I want to pass the constants MATRIX and MATRIX2 to the other subs. But everytime I try to run the debugger, I get the error:

Compile error:
Invalid attribute in Sub or Function

I am using Microsoft Excel 2003 SP1 and VB 6.3 Version 9972. Any ideas or tips would be greatly appreciated!