The linked cells for the scrollers can only contain a value and not a formula.
Instead you need to hook into the scroller events.
right click sheet tab and pick View code. Paste the following.
Private m_blnUpdating As Boolean
Private Sub ScrollBar1_Change()
If m_blnUpdating Then Exit Sub
m_blnUpdating = True
ScrollBar2.Value = Range("L7")
m_blnUpdating = False
End Sub
Private Sub ScrollBar1_Scroll()
If m_blnUpdating Then Exit Sub
m_blnUpdating = True
ScrollBar2.Value = Range("L7")
m_blnUpdating = False
End Sub
Private Sub ScrollBar2_Change()
If m_blnUpdating Then Exit Sub
m_blnUpdating = True
ScrollBar1.Value = Range("L5")
m_blnUpdating = False
End Sub
Private Sub ScrollBar2_Scroll()
If m_blnUpdating Then Exit Sub
m_blnUpdating = True
ScrollBar1.Value = Range("L5")
m_blnUpdating = False
End Sub
Bookmarks