Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Method of Range class failed | Excel Programming | |||
Select method of Range class failed - but why??? | Excel Programming | |||
select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming |