Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Control (TextBox) question
Using Excel 2000.
The textbox is embedded directly into the sheet. When the workbook (with its single sheet) is opened, the textbox is visible and accessible to the user. Can I control access to the textbox, so that it is only accessible under certain conditions? For example, in the ThisWorkbook module I have code in the Workbook_Open Event. Can I do something like: If ContractMaster = True Then Enable the Contol Else User cannot edit the textbox Is this possible please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Control (TextBox) question
Hi Stuart,
To hide the textbox,try: ActiveSheet.OLEObjects("Textbox1").Visible = True To prevent editing, try: ActiveSheet.OLEObjects("Textbox1").Enabled = True --- Regards, Norman "Stuart" wrote in message ... Using Excel 2000. The textbox is embedded directly into the sheet. When the workbook (with its single sheet) is opened, the textbox is visible and accessible to the user. Can I control access to the textbox, so that it is only accessible under certain conditions? For example, in the ThisWorkbook module I have code in the Workbook_Open Event. Can I do something like: If ContractMaster = True Then Enable the Contol Else User cannot edit the textbox Is this possible please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Control (TextBox) question
Many thanks.
Will give them a go. Regards. "Norman Jones" wrote in message ... Hi Stuart, To hide the textbox,try: ActiveSheet.OLEObjects("Textbox1").Visible = True To prevent editing, try: ActiveSheet.OLEObjects("Textbox1").Enabled = True --- Regards, Norman "Stuart" wrote in message ... Using Excel 2000. The textbox is embedded directly into the sheet. When the workbook (with its single sheet) is opened, the textbox is visible and accessible to the user. Can I control access to the textbox, so that it is only accessible under certain conditions? For example, in the ThisWorkbook module I have code in the Workbook_Open Event. Can I do something like: If ContractMaster = True Then Enable the Contol Else User cannot edit the textbox Is this possible please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.714 / Virus Database: 470 - Release Date: 02/07/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Excel ActiveX TextBox Question | Excel Discussion (Misc queries) | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) | |||
Question regarding an activex control button | Excel Programming | |||
Dynamic TextBox ActiveX events | Excel Programming |