excel doesn't offer anything that can protect/reprotect your project.

A few people have used Sendkeys--but that's not too reliable.

Bill Manville's post has been suggested a few times...

http://groups.google.co.uk/group/mic...47ea006527ed5e

or

http://snipurl.com/a049

But I wouldn't use it in production.

=====
Maybe you can add a new workbook, and create the temporary userform there. But
be aware that there is a setting (xl2002+) that each user can set that may cause
you trouble:

Tools|macro|security|trusted publishers tab|
If "Trust access to Visual Basic Project" is unchecked, you've still got
trouble.

Another option (that might even be easier???) is to design your form for the
worst case.

Then just hide the controls you don't need.


wrote:

My VBA code is password protected. I need to create a Userform and
associated code on the fly... this is not problem. But releasing the
password to run the procedure IS!! Is there away around this?
I need to make it seamless so users are not aware of any
unprotect/protect activity in the background.

--

Dave Peterson