It used to work in Excel 2013. But changing from one window to another no longer seems to fire any event. I am talking about two windows onto the same workbook.
Is there a workaround for this?
It used to work in Excel 2013. But changing from one window to another no longer seems to fire any event. I am talking about two windows onto the same workbook.
Is there a workaround for this?
I just tried putting
Private Sub Workbook_WindowActivate(ByVal Wn As Window)
MsgBox Application.ActiveWorkbook.Name & " " & Application.ActiveWindow.WindowNumber
End Sub
And it fired and shows the window number correctly. So what code are you trying to use?
Thank you for that. There was an obscure reason why it stopped working for Office 365 and I fumbled a test. Looking harder found it.
Not an Excel bug.
Windows? Please use precise language. Excel is a SDI application (single document interface) so it cannot have multiple "windows" open. Do you mean a single workbook with several worksheets? Or do you mean two instances of Excel, each with one document open.
Um, I am talking about the WindowActivate Event moving between two windows onto the same workbook. One Excel process.
Open a workbook. Select View > New Window. You will get two windows onto the same workbook. An ancient feature.
4 people are following this question.