BravesPiano5
03-26-2013, 01:10 PM
Some of this may partain to VBA and some of it may not...I work with multiple worksheets and would like to have them both displayed on separate monitor screens. Currently, I have to open a new excel file then open the worksheet I desire which I find too cumbersome. Is there a way to both open a new instance of Excel and have it display the file name only (not Microsoft Excel - MyFileName but rather simply MyFileName)?
A couple of things I found is under Excel File>Options>Advanced>General, click the option to Ignore other applications that use DDE. However, sometimes when opening a brand new file, Excel opens but the workbook does not.
Additionally, I found the below code that can be saved to Personal.XLSB which I seem to get errors with:
Private Sub Workbook_Open()
Application.Caption = ActiveWorkbook.FullName
End Sub
Any ideas? I'm sure it's something simple but I haven't found the answer. :)
A couple of things I found is under Excel File>Options>Advanced>General, click the option to Ignore other applications that use DDE. However, sometimes when opening a brand new file, Excel opens but the workbook does not.
Additionally, I found the below code that can be saved to Personal.XLSB which I seem to get errors with:
Private Sub Workbook_Open()
Application.Caption = ActiveWorkbook.FullName
End Sub
Any ideas? I'm sure it's something simple but I haven't found the answer. :)