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.
|