Hi,
I have a spreadsheet that when inactive disappears from the taskbar, in fact it never appears in the taskbar, the only way I can view it is to click on View>Switch Windows and then select the speadsheet from the list of open files.
I can't understand why this keeps happening, any ideas?
The only code i have in the workbook is a macro that opens another spreadsheet upon opening. I've inlcuded this below, i can't see that it would cause any problems but just in case.
I have a spreadsheet that when inactive disappears from the taskbar, in fact it never appears in the taskbar, the only way I can view it is to click on View>Switch Windows and then select the speadsheet from the list of open files.
I can't understand why this keeps happening, any ideas?
The only code i have in the workbook is a macro that opens another spreadsheet upon opening. I've inlcuded this below, i can't see that it would cause any problems but just in case.
Code:
Private Sub Workbook_Open()
'
' Macro5 Macro
'
'
ChDir "K:\Prime\Clients"
Workbooks.Open Filename:= _
"K:\Prime\Clients\Prime Clients Packaging Requirements.xls"
Windows("Prime Pipeline.xls").Activate
Range("A1").Select
End Sub
