Open Userform in different workbook

[Endorphin]

Hi All,

I have two workbooks, both completely userform driven, the user does not get to see the worksheets at any stage.

What I am trying to do is swap workbooks via the userforms so clicking a command button opens up the second workbook and Userform and saves the original one.

I have the code to automatically open the userform when the work book is loaded but it does not seem to work while swapping, however it does work when used individually.

Any help appreciated.

Neil

 

[Endorphin]

Thanks I will have to try it at home, as we are not allowed ti install anything at work.
But I will try the manual approach though.

Thanks Again Rory

 

[Endorphin]

Could using this fix a problem I have,
"Object has been disconnected from its clients"

It happen when a user goes through a userform all in one go without saving and then occures at the same point each time. To reset is I open the document, disable macros then save it and it works again.

It does not happen on the user that has completed the form in one go but the one after..

 

[RoryA]

That sounds more like a coding issue to me, to be honest.

 

[Endorphin]

Im re writing it at the moment anyway.

Again, thanks for your help Rory.