Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The problem with comparison of text as well as the password from
I created form UserForm with TextBox and Button.
How to compare the string (text) from TextBox as well as password from VBAProject Properties - Protection - Password. I would like to mention, that I put propriety PasswordChar (for TextBox) = *. Does this have some meaning? What I should write in event CommandButton1_Click() ? Kind Regards, Andrzej |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
The problem with comparison of text as well as the password from t
You have no access to the project password programmatically. Certainly not
for reading and for setting the best you can do is sendkeys. You should already know it, so you could include it in your code - but even so, not sure of what purpose it would serve. -- Regards, Tom Ogilvy "And1" wrote: I created form UserForm with TextBox and Button. How to compare the string (text) from TextBox as well as password from VBAProject Properties - Protection - Password. I would like to mention, that I put propriety PasswordChar (for TextBox) = *. Does this have some meaning? What I should write in event CommandButton1_Click() ? Kind Regards, Andrzej |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
The problem with comparison of text as well as the password fromt
OK,
and to what is the command ?: "ActiveWorkbook.HasPassword" Kind Regards, Andrzej Tom Ogilvy napisał(a): You have no access to the project password programmatically. Certainly not for reading and for setting the best you can do is sendkeys. You should already know it, so you could include it in your code - but even so, not sure of what purpose it would serve. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
The problem with comparison of text as well as the password fr
from help on HasPassword property of the workbook object:
True if the workbook has a protection password. Read-only Boolean. Remarks You can assign a protection password to a workbook by using the SaveAs method. This has nothing to do with the project password in the vbe. You can't lock a project without a password. -- Regards, Tom Ogilvy Maybe you are looking for something like: Application.VBE.ActiveVBProject.Protection Which returns true if the activeproject in the vbe is locked. "And1" wrote: OK, and to what is the command ?: "ActiveWorkbook.HasPassword" Kind Regards, Andrzej Tom Ogilvy napisał(a): You have no access to the project password programmatically. Certainly not for reading and for setting the best you can do is sendkeys. You should already know it, so you could include it in your code - but even so, not sure of what purpose it would serve. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif - For Each problem (several column comparison) | Excel Programming | |||
Text Comparison | Excel Programming | |||
Text Comparison | Excel Programming | |||
text comparison | Excel Programming | |||
If then Cell comparison with text. | Excel Programming |