Good day to all,
I am trying to insert a scrollbar at a specific cell position using VBA.
A macro recorder would usually insert a scrollbar using this code
However, I would like to define the top, left, width and height of the scroll bar. I tried defining the scrollbar as an object, create it using the default, and then selecting it to modify its properties (see code below). But this did not work.
This scrollbar is not inside a userform or frame. It is located on a spreadsheet to control a dynamic cell scrolling.
Thanks.
Bookmarks