ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   textbox disable scrollbars enable (https://www.excelbanter.com/excel-programming/351590-textbox-disable-scrollbars-enable.html)

herb

textbox disable scrollbars enable
 
Hello,

following situation:

i've a form in which reports can be created an viewed. this means,
reports from the past can be viewed but not changed (security
reason....).

by now i did it like this that a set textbox.enable=false.

this prevented any changes. but if the text exeeds the height of the
textbox, the lower part can be displayed because the scrollbars are
deactivated.

so, is there a possibilty to scroll through a past report without the
possibility to change?


thanks in advance,
herb


Leith Ross[_493_]

textbox disable scrollbars enable
 

Hello Herb,

Yes you can. Leave your ScrollBars Enabled and set the TextBox Locke
property to True.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=50553


herb

textbox disable scrollbars enable
 
thanks for the response.....

i didn't know that the scrollbars also can be enabled or disabled

it is possible now to write some text into the textbox, but the changes
are not adopted...


thanks a lot,
herb



All times are GMT +1. The time now is 06:14 PM.

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