User Form Manipulation

[qureshi]

I have 5 workbooks for my data. I have created a 6th workbook which only hold a blank worksheet and a user form. The user form has command buttons. One for opening each workbook.
When i open the workbook which has the user form and click one of the command buttons, the spreadsheet open but in the background. The user form is on the top so i cannot edit the worksheet.
Then i put the following commad with the click event
userform1.hide
It works, but now i cant open any other worksheet as the form is no longer there.
Help is needed OR a better idea to achieve the results.

Target is to view the workbooks as the users requires.

Thanks all in advance.

 

[acron]

Could you abandon the user form and place 5 independent buttons on the blank worksheet to open each of the workbooks ?

Just a though if all the userform does is open the 5 workbooks.

A.C.

 

[qureshi]

Yes i could do that,The form gives a good custom feeling.

 

[acron]

If you are using XL2000 or later you can set the UserForm to open in a non-modal state. To show the form in such a state you can use :

Userform1.Show vbModeless

That should enable you access the workbook whilst the Userform is still visible. After opening the workbook, you may need to activate the workbook window, with

Application.Windows("WorkbookName.xls&quot.Activate

A.C.