Scroll in Excel worksheet OLE

Hi All,

I have an Excel OLE in my VB6 form and it is disabled. I do not want the user to edit it at all. I use it only to preview an Excel document.

How can I scroll my worksheet while the OLE is disabled?

I tried:
FinalOLE.object.Activewindow.ScrollColumn = HScrollBar_E.Value + 1
and it did not work! any ideas?

Thanks,

-George

and it did not work! any ideas?
Come on George, you can manage better than that :rolleyes: How do you know it didn't work? Did you get an error, did absolutely nothing happen, did the code even compile? Details if you please...

Sorry my firend, I thought you can try it, it was a one line code!

I got an error 438, object does not support this property or method.

However, I decided to save my Excel file as HTM and view it in a Webbrower control.

I have a question about that but I will ask it in the right forum.

Thanks anway,

- George