Is it possible to password protect an OLE object on a sheet?

Q

quartz

Hello, please help if you can. I am using VBA in Excel XP with Windows 2000

I have a form on a protected spreadsheet that includes some ActiveX drop down controls
One of these controls will have only three choices, "Blank", "Approve" or "Deny".

I want to make only this particular control password protected so that only specific users can access it

Is this possible? Any other suggestions

Thanks much in advance for your assistance.
 
A

AA2e72E

I don't think you can protect access to a control using password. The usual technique is either to hide the control (visible = false) or to disable it (enabled = true)

Now all you need is to identfy the user. In a Workbook_open macro, you can identify the current user with application.Username. If the user does not qualify, hide or disable the control

Better still: Save your workbook with those controls hidden or disabled (ensure that the controls are in an appropriate state). In the Workbook_Open event macro, check the user name and enable if appropriate.
 
Top