ActiveSheet woes
 

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

ActiveSheet woes
 

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/

ActiveSheet woes
 

Frank,

I think Print_Area is an automatic name when you select part of a sheet to
print. Excel creates it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
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/