Macro Variables

[RichardU]

I have a variable i want to use through-out my workbook, but Excel does not seem to let me i have defined it etc

Sub Auto_Open()
Dim ImprestProtected As Integer
ImprestProtected = 1
End Sub

and

Private Sub Worksheet_Activate()

If ImprestProtected = 0 Then Exit Sub
UserForm12.Show

End Sub

you get the idea.

How can i do this?

 

[QuietRiot]

use

Public ImprestProtected As Integer
place it above macro

 

[Lewiy]

You need to delcare the variable outside of a procedure (i.e. before any other code). Then it will be a "public" variable and can be used across other procedures.

There is further information under "Understanding Scope and Visibility" in the VBA help files.

 

[RichardU]

Ok i understand now so what does the line

Option Explicit

mean in the code below?

Option Explicit
Public SignatureList As String

 

[RichardU]

Ok i understand now so what does the line

Option Explicit

mean in the code below?

Option Explicit
Public SignatureList As String

 

[VoG]

Option Explicit means that you have to declare (Dim) all your variables. This is a very good idea IMHO as it avoids errors with typos.

 

[Lewiy]

More on Option Explicit here:
http://www.cpearson.com/excel/DeclaringVariables.aspx