How to make created button move with scrollbar?
Hi Bon,
Excel doesn't have a scroll event. Selection change was the closest I
could get to what you are after.
Changing: .Left = Target.Left - .Width to ...
.Left = Cells(1,ActiveWindow.ScrollColumn).Left
will keep the button on the left side of the screen.
I think a customised toolbar would be a better solution.
Ken Johnson
|