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

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.

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

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.