Send us the code and let us know where you are placing it?

"Richard" wrote:

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