Is this a bug?

[DHS100]

Sorry for the lame title, but I'm confused.

I have a workbook with VBA. It ran fine on my machine but when I emailed it out, people got errors. I then downloaded the copy I sent out and also got the errors (no differences between the working copy and the email one, other than one was emailed). The line it breaks on can then IMMEDIATELY be F8'd through.

Things that might be important are:

* The code breaks after clicking "Enable" on "The file originated from an Internet location and might be unsafe. Click for more details"
* The line it breaks on gives "Method 'Worksheets' of object 'Global failed"
* Pressing debug and then F8 sometimes then works or sometimes gives "Can't move focus to the control because it is invisble, not enabled, or of a type that does not accept the focus".
* Pressing F8 again gives (sometimes) "Method 'Worksheets' of object 'Global failed"
* The line in question reads: If Worksheets("DATA").[A1].Value = vbNullString Then
* Also, that sheet was invisible but isn't now.

Any ideas? I tried renaming the worksheet and back again but no...

 

[Norie]

Have you tried using Range instead of the [] shortcut?

If Worksheets("DATA").Range("A1").Value = vbNullString Then

You could also try changing vbNullString to "".

 

[DHS100]

It turned out to be this bug causing the issues:
Object Model calls may fail from WorkbookOpen event when exiting Protected View