If you are using xl2002 or later and your security is set to high, then
macros are disabled without warning unless you have certified your code and
your certification has been accepted as a trusted source.

If that is what is happening, then I doubt using some other approach is
going to overcome it.

--
Regards,
Tom Ogilvy

"Richard" wrote in message
...
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