Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(


Any help would be greatly appreciated

Hi,

I don't have much experience in code on web based dooks, but how about
just naming the range in Excel and then your code just becomes:

Range("MyCustomNameHere").Select

I would think this would be less particular about the Application
object model.

P.S. This is completely untested... just an idea.

Cheers,
Ivan.


On Apr 1, 8:44*pm, Istvan wrote:
Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. *However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(

Any help would be greatly appreciated

I've just tried your suggestion, but it doesn't do the trick.
First attempted was done by creating a name, and trying to access it with:
Application.Range("EmployerClass").Select
which resulted in a Method 'Range' of object '_Application' failed
Then i tried with
ThisWorkbook.ActiveSheet.Range("EmployerClass").Se lect
which resulted in the Select method of Range class error again

greetz

Istvan

"Ivyleaf" wrote:

Hi,

I don't have much experience in code on web based dooks, but how about
just naming the range in Excel and then your code just becomes:

Range("MyCustomNameHere").Select

I would think this would be less particular about the Application
object model.

P.S. This is completely untested... just an idea.

Cheers,
Ivan.


On Apr 1, 8:44 pm, Istvan wrote:
Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(

Any help would be greatly appreciated

Hi,

Did you happen to try just:

Range("EmployerClass").Select

?

Cheers,

On Apr 1, 10:28*pm, Istvan wrote:
I've just tried your suggestion, but it doesn't do the trick.
First attempted was done by creating a name, and trying to access it with:
Application.Range("EmployerClass").Select
which resulted in a Method 'Range' of object '_Application' failed
Then i tried with
ThisWorkbook.ActiveSheet.Range("EmployerClass").Se lect
which resulted in the Select method of Range class error again

greetz

Istvan



"Ivyleaf" wrote:
Hi,

I don't have much experience in code on web based dooks, but how about
just naming the range in Excel and then your code just becomes:

Range("MyCustomNameHere").Select

I would think this would be less particular about the Application
object model.

P.S. This is completely untested... just an idea.

Cheers,
Ivan.

On Apr 1, 8:44 pm, Istvan wrote:
Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. *However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(

Any help would be greatly appreciated- Hide quoted text -

- Show quoted text -

Tried that before, but double checked it for you.
Doesn't help either, just another variation of the same error:
Method 'Range' of object '_Global' failed.

I just noticed that in my original post i forgot to mention that the
function is located in a module, so not in a sheet. I assume that's why just
using Range doesn't work.

"Ivyleaf" wrote:

Hi,

Did you happen to try just:

Range("EmployerClass").Select

?

Cheers,

On Apr 1, 10:28 pm, Istvan wrote:
I've just tried your suggestion, but it doesn't do the trick.
First attempted was done by creating a name, and trying to access it with:
Application.Range("EmployerClass").Select
which resulted in a Method 'Range' of object '_Application' failed
Then i tried with
ThisWorkbook.ActiveSheet.Range("EmployerClass").Se lect
which resulted in the Select method of Range class error again

greetz

Istvan



"Ivyleaf" wrote:
Hi,

I don't have much experience in code on web based dooks, but how about
just naming the range in Excel and then your code just becomes:

Range("MyCustomNameHere").Select

I would think this would be less particular about the Application
object model.

P.S. This is completely untested... just an idea.

Cheers,
Ivan.

On Apr 1, 8:44 pm, Istvan wrote:
Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(

Any help would be greatly appreciated- Hide quoted text -

- Show quoted text -

Sorry Istvan,

That's me out of ideas. I tried to recreate the problem by sticking a
workbook with that code on my server, but I'm buggered if I can get IE
to open it in the browser... keeps opening it with Excel. Hopefully
someone else will be able to help.

Cheers,

On Apr 1, 11:08*pm, Istvan wrote:
Tried that before, but double checked it for you.
Doesn't help either, just another variation of the same error:
Method 'Range' of object '_Global' failed.

I just noticed that in my original post i forgot to mention that the
function is located in a module, so not in a sheet. *I assume that's why just
using Range doesn't work.



"Ivyleaf" wrote:
Hi,

Did you happen to try just:

Range("EmployerClass").Select

?

Cheers,

On Apr 1, 10:28 pm, Istvan wrote:
I've just tried your suggestion, but it doesn't do the trick.
First attempted was done by creating a name, and trying to access it with:
Application.Range("EmployerClass").Select
which resulted in a Method 'Range' of object '_Application' failed
Then i tried with
ThisWorkbook.ActiveSheet.Range("EmployerClass").Se lect
which resulted in the Select method of Range class error again

greetz

Istvan

"Ivyleaf" wrote:
Hi,

I don't have much experience in code on web based dooks, but how about
just naming the range in Excel and then your code just becomes:

Range("MyCustomNameHere").Select

I would think this would be less particular about the Application
object model.

P.S. This is completely untested... just an idea.

Cheers,
Ivan.

On Apr 1, 8:44 pm, Istvan wrote:
Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. *However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(

Any help would be greatly appreciated- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Try the following macro in the workbook code area:

Private Sub Workbook_Open()
Sheets("Home").Activate
Range("C4").Select
End Sub

REMEMBER: the workbook code area, not a standard module.

--
Gary''s Student - gsnu200776


"Istvan" wrote:

Tried that before, but double checked it for you.
Doesn't help either, just another variation of the same error:
Method 'Range' of object '_Global' failed.

I just noticed that in my original post i forgot to mention that the
function is located in a module, so not in a sheet. I assume that's why just
using Range doesn't work.

"Ivyleaf" wrote:

Hi,

Did you happen to try just:

Range("EmployerClass").Select

?

Cheers,

On Apr 1, 10:28 pm, Istvan wrote:
I've just tried your suggestion, but it doesn't do the trick.
First attempted was done by creating a name, and trying to access it with:
Application.Range("EmployerClass").Select
which resulted in a Method 'Range' of object '_Application' failed
Then i tried with
ThisWorkbook.ActiveSheet.Range("EmployerClass").Se lect
which resulted in the Select method of Range class error again

greetz

Istvan



"Ivyleaf" wrote:
Hi,

I don't have much experience in code on web based dooks, but how about
just naming the range in Excel and then your code just becomes:

Range("MyCustomNameHere").Select

I would think this would be less particular about the Application
object model.

P.S. This is completely untested... just an idea.

Cheers,
Ivan.

On Apr 1, 8:44 pm, Istvan wrote:
Hi all,

I got this problem which is driving me nuts.

In a macro i have the following line
ThisWorkbook.Sheets("Home").Range("C4").Select

I want to do this to be a bit more user friendly.
This works fine as long as the workbook is opened in excel. However, the
workbook is available on our customers website, and users that use IE7 are
complaining. It seems that when they click the link, and choose open instead
of save, the error message in the subject appears on the select line.

I've already tried some alternatives:
* first activate the sheet, then try to select the cell
* select the sheet, then select cell = select on "_worksheet" failed
* tried to use activate, no luck
The frustrating part is that all the solutions i've tried work well in
excel, but are failing when opening the workbook in IE7 :-(

Any help would be greatly appreciated- Hide quoted text -

- Show quoted text -