ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   password protection (https://www.excelbanter.com/excel-programming/341801-re-password-protection.html)

dominicb[_145_]

password protection
 

Good morning Neil Pattison

To do this you are probably better off using a textbox on a userform
and set the PasswordChar property to "*". That is certainly the easier
way.

However, if you really want to continue using an input box, Daniel
Klann has devised a way to get around the problem by using a series of
API calls to intercept and translate the key presses. See his article
he

http://www.xcelfiles.com/API_09.html

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=472890



All times are GMT +1. The time now is 10:07 AM.

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