I have several command buttons placed on one of my worksheets in the first two rows at the top left of my screen. I can freeze panes to keep them in place when I scroll down but I cannot do this when scrolling to the right. (Because there are several buttons there is a section of data that will always be shown; which I want to avoid.)
I have searched google a bit but there doesn't seem to be many similar problems. If I wanted to keep the command button in a position relative to the sheets upper left visible corner what is the code I'd use?
What I have is this.
Where Load_Page is the name of my first command button. This in itself is useless to me. But it is close to what I need. The question is... is there a reference to the top left of the visible screen that I could put in place besides Range("A1") and 0?![]()
Please Login or Register to view this content.
Bookmarks