View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default 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.