Userform to stay open in a different sheet while editing

[JLouis]

Hello. My challenge today it to successfully code the following:
I have 2 WB's, say WB1 & WB2
While using WB1 I use code to go to and work on WB2. I need a visible, floating button that I can click in WB2 to return seamlessly back to WB1.

I've tried several bits of code to open a userform in another workbook without satisfactory results.

Any suggestions would be appreciated.

Louis

 

[steve the fish]

Do you mean like this:

UserForm1.Show vbModeless

 

[JLouis]

Yes. That is the macro to show in WB2. It is called from WB1 but is not working properly. There are actually 2 separate macros called in WB2. The first macro calls a specific page in WB2 to open, the 2nd one calls the userform.

Sub CallAnotherMacro()

Application.Run "'Another Workbook.xlsm'!NameOfMacro"

End Sub

I guess I need to be able to call 2 different macros in WB2.

Thank you for the reply.

 

[JLouis]

To bring this discussion full circle, this is the macro calling the first procedure:
Sub mon_o()
'

On Error GoTo ErrorHandler
Windows("276 Scheduling Program.xlsm").Activate
Application.Run "'276 Scheduling Program.xlsm'!MONDAYTemplate"
Exit Sub
ErrorHandler:
MsgBox ("The 276 Scheduling Program is not open. Please open the file and rerun the macro.")

End Sub

This works properly. So now I want to create a button that shows on the 2nd workbook that, when pressed, will take me back to the original WB. Sorry I haven't expressed myself properly.

 

[JLouis]

SOLVED:
Not sure why this is working now, but the answer to my problem was the code shown below. I wrote the TestByWorkbookName a little different on WB2.

Sub mon_o()
'
On Error GoTo ErrorHandler
Windows("276 Scheduling Program.xlsm").Activate
Application.Run "'276 Scheduling Program.xlsm'!MONDAYTemplate"
Application.Run "'276 Scheduling Program.xlsm'!TestByWorkbookName"
Exit Sub
ErrorHandler:
MsgBox ("The 276 Scheduling Program is not open. Please open the file and rerun the macro.")

End Sub