if worksheet called from menu userform is minimised menu userform disappears - can this be

As above... menu userform works well until a worksheet within the workbook is called my the menu and viewed. Worksheet cannot be "closed" because part of the active workbook, but when minimised the focus doesnt return to the menu userform which disappears with the minimised worksheet and doesnt return. Cant call userform again because it it is populated by a activate macro.

I just need the menu userform to show again.

Workbook attached... selct incident file...select view databse and youll see what I mean

Any ideas appreciated

I just need the menu userform to show again.

what is the name of this form in your file
When clicking View Database must the form be hidden so that you can view the database

The secondary user form is F06_DbViewer which does not need to be visible. A dbl_Click event fires another entry userform for updating that entry

when finished it would be preferable to display the F01_NewMenu again - I tried a worksheet deactivate but didn't work

Please excuse me for not understanding....

selct incident file...select view databse and youll see what I mean

When I select incident file F10_Incident form Shows
What must now happen when you press database

K so after Database press The main Form shows vbModeless...What do you want to do from there....
Why not just close the Main form and then have a command button on data sheet to call Whateva form you want next

Full database has thousands of entries, it would require a floating command button always visible even after scrolling. I could solve the problem by putting the database into a new workbook but this is the way they want it here. They see it as its a dead end if they open the database and the workbook has to be closed and re opened to do anything else.

I even added a minimise to the main menu to get around other problems but cant find a way to keep the Main Menu minimised in a corner or something that can then be maximised.

Why not just freeze the top pane of Database and place the command button there.

Went that way Sintek... Moved code from Userform open to a module Sub called from Open and then can be called from a button macro on worksheet

Not elegant but works lol

Thanks for the input Sintek

Jut wish i understood the inner workings....Surely could come up with simpler method...Not to worry. if it works it works.