View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Protection in VB

Hello,

I've read dozens of posts regarding this issue however, I am at a loss.

It is mandatory that I have the worksheet protected so that data is only
entered via VB userform. I have tried the Workbook_Open() and it is not
being executed. I replaced the code with a MsgBox and confirmed it is not
being run. The macro is being invoked via mouseclick (no shift key). Where
else would I place UserInterfaceOnly?

Thanks,
Richard