Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc macro to display same section when switching sheets

I would be grateful if someone could help me with a problem I have in Calc. After having scrolled down and across sheet #1 of my worksheet so that, for example, the cell AA50 is in the upper left-hand corner I want to click on the tab 'sheet #2' and make the corresponding cell (AA50) of sheet #2 be displayed at the upper left hand corner. In other words I want to be able to see the same section of a sheet when I change sheets - to make it appear as if they were synced to each other.

There does not seem to be any simple way of doing this, so I suppose I must write a macro that looks for the upper left hand corner of sheet #1 and then displays the same cell of sheet #2 in that position. This macro must then be attached to the sheet #2 tab. Having never written a macro for LO Calc I have no idea how to start. I would therefore be very thankful for any help from the community.