Hi everybody,

I made a form which opens "on activate worksheet". Everything worked fine. I then needed to use the same form (with a few alterations) on another sheet in the same book. So I made a new form using the first one as a template, and everything worked fine. I opened the second sheet and up popped the form. I closed it, and opened the first one (the one that worked from the start), and got a system error "&H80070057 (-2147024809)", and when clicking OK got an error 361. The debug shows the show-command in the "worksheet activate" as the cause...

Being a total newbie to VB the following code might seem, well, strange to some...
Please Login or Register  to view this content.
The code of the second form is essentially the same.

Anybody any ideas?