I'd look into a combination of the Worksheet_SelectionChange event and
the Visible property of the spin button. When the target passed into
the SelectionChange event isn't the linked cell, set Visible = False.


stewdizzle wrote:
Is there a way to hide a spin button when the linked cell is not active?