View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Istvan Istvan is offline
external usenet poster
 
Posts: 12
Default Select method of Range class failed

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