variable not defined issue

[RhodEvans]

Morning,

I'm getting a Variable Not Defined error and would be grateful of some help, or to be pointed in the right direction please.

in my workbook_open I have the following code

Dim workround As Integer
workround = 0

in one of my sheets worksheet_change I have

If workround = 0 then

when I get to this I get the Variable not defined error. I am using this to bypass some code that does not always need to be run (it slows the workbook down). So I also have another piece of code that toggles workround from 0 to 1.

I have a feeling this error has something to do with Option Explicit. But My limited understanding is obviously insufficient to know what is happening or how to fix it. As I believe that I have defined the variable within the workbook_open code.

Can anybody help me with this please??

 

[RoryA]

If the variable declaration is within your Workbook_Open code, that is the only place it has any meaning - the variable has no scope anywhere else. Move the declaration to the top of a normal module and make it public:

Public workround As Integer

and you should be fine. (make sure you do not leave the original 'dim' line in the Workbook open code)

 

[RhodEvans]

Sometimes it's really obvious when someone points it out to you. But thank you very much because I never would have got there on my own!

 

[RoryA]

Always glad to help.