Returning to Main Tab
Posted by Del on April 20, 2000 7:58 AM
I have a problem,
I can't get this macro to return to the "Main" tab when it has moved open worksheets to this workbook (SK Compiler).
It always stays (I think) on the last tab it has moved from another workbook.
It's probably really simple, but I can't do it!
Please help, Thanks in advance.
(Below is my macro for this)
Do Until Empty
Application.ScreenUpdating = False
ActiveSheet.Move After:=Workbooks("SK Compiler.xls").Sheets(2)
ActiveWindow.DisplayWorkbookTabs = True
Application.DisplayAlerts = False
If ActiveWorkbook.Name = "SK Compiler.xls" Then End
Application.DisplayAlerts = True