Ok I have a previous version of a file saved in Excel 2000 for xp
...in German.

Now i have installed a German windows XP with Excel 2003 in English.

So i thought i better translate some things (although most things ar
naming so it shouldn't be a problem:
For example This:

Sub DruckbereichAuswählen()
Range("Druckbereich").Select
End Sub

To this:

Sub DruckbereichAuswählen()
Range("Print_Area").Select
End Sub

But it still refuses to work, Citng the error....
Method 'Range' of object '_Global' failed

so i'm assuming there is some naming problem. All the other macros,
such as

Sub BlattschutzAufheben()
ActiveSheet.Unprotect
Cells(1, 6) = "Zellen NICHT geschützt"
End Sub

..give me errors Method 'Unprotect' of 'object _Worksheet' failed.

is the _worksheet or _Global things a dead giveaway for something

--
Message posted from http://www.ExcelForum.com