ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Scroll Bar Position in imbedded Text Box (https://www.excelbanter.com/excel-programming/423318-scroll-bar-position-imbedded-text-box.html)

[email protected]

Scroll Bar Position in imbedded Text Box
 
I am using an imbedded text box on the opening page of my workbook. I
have two questions for the experts;

1) Sometimes the scroll bar does not appear until you click inside of
the cell, and at other times, it appears almost automatically. I
would like for it to always be displayed so that users know there is a
sroll bar available. I saw instructions on how to do this when the
text box is on a form, but how do you do it when the text box is
imbedded into a worksheet page rather than a form?

2) I would like for the scroll bar to be reset to the top of the page
whenever this page is opened. By the way, this page opens only once -
and that is when the workbook is first opened - if that helps.

Thanks for the help, everyone. It is appreciated.


All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com