sryabinin
07-31-2008, 07:16 AM
I'm not sure if this should be posted in a different forum but since I am working in excel I think it applies here too..
I have a form with several OWC spreadsheets on it. Right now they scroll independently of one another. What I need to do is to syncronize the scrolling between two of the spreadsheets. I dont know if this is the right way to go about it but I decided to use a ScrollBar control object and somehow link both the Spreadsheet objects to the scroll bar, this was before I realized that Spreadsheet objects dont have a Scroll method. So now I am out of ideas.
I could consolidate spreadsheets into one large one and use freeze some of the columns but that makes complications with other bits of the macro I am trying to write.
Anyone have an idea on how to get this working?
I have a form with several OWC spreadsheets on it. Right now they scroll independently of one another. What I need to do is to syncronize the scrolling between two of the spreadsheets. I dont know if this is the right way to go about it but I decided to use a ScrollBar control object and somehow link both the Spreadsheet objects to the scroll bar, this was before I realized that Spreadsheet objects dont have a Scroll method. So now I am out of ideas.
I could consolidate spreadsheets into one large one and use freeze some of the columns but that makes complications with other bits of the macro I am trying to write.
Anyone have an idea on how to get this working?