Hide and then open the workbook again after another

[aman1234]

Hi guys

I have two workbooks and the following code is written in it. I need help to write code for Logoff button for Sample2 workbook.

Code for Sample1 workbook:

Please Login or Register  to view this content.

There is a button "Enter" on Userform1 and when I press the button then the following code executes:

Please Login or Register  to view this content.

Now on sample2 workbook the following code is written:

Please Login or Register  to view this content.

And there is a "Logoff" button in userform1 so when the user clicks this button then the sample2 workbook should be closed and the userform1 in sample1 workbook should become visible. I am not able to do this part.

Any help would be much appreciated...

Thanks

[pike]

hi aman1234
try this....

Please Login or Register  to view this content.