ActiveWorkbook.SaveAs Filename:= _
"C:\Users\uscp\Documents\Shortage Report.xlsx", FileFormat:=xlOpenXMLWorkbook _
, CreateBackup:=False
Workbooks.Open Filename:= _
"C:\Users\uscp\Documents\NC Parts List with Vendors.xlsx"
Windows("Shortage Report.xlsx").Activate
ActiveWindow.SmallScroll ToRight:=5
Columns("L:L").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
It stops right after
Workbooks.Open Filename:= _
"C:\Users\uscp\Documents\NC Parts List with Vendors.xlsx"
I've only copied the beginning section of the code. Let me know if you need all of it.
Oh, on another note. I've tried moving the "Workbooks.Open" code to a different section of the macro (just before the macro needs the information from the other workbook) and I still get the same result, works fine up to that section, opens the workbook and then just stops, but if I run it from the view macro menu, the entire macro works fine.
Bookmarks