Hi
for the first macro you also have to define a name (Insert - Define -
Name) called 'Print_area'. If you don't do this Excel will not knwo
which range to select

The second macro should do


--
Regards
Frank Kabel
Frankfurt, Germany


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 are
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/