ExcelBanter - Hide Spin Button

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hide Spin Button (https://www.excelbanter.com/excel-programming/380375-hide-spin-button.html)

stewdizzle

Hide Spin Button

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

[email protected]

Hide Spin Button

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?

All times are GMT +1. The time now is 02:55 AM.