Could it be an AutoOpen macro in your personal macro file?
By way of background, I have had no prior experience with VBA, and so I found myself at a sticking point with this issue.
Today I thought it would be valuable if I had some macros in place in order to help expedite some of my work. I successfully integrated some codes (through copy and paste) into Excel; however, I entered in the following code as a means to Copy a Worksheet into a New Workbook:
Dim NewName As String
Dim nm As Name
Dim ws As Worksheet
If MsgBox("Copy specific sheets to a new workbook" & vbCr & _
"New sheets will be pasted as values, named ranges removed" _
, vbYesNo, "NewCopy") = vbNo Then Exit Sub
.ScreenUpdating = False
' Copy specific sheets
' *SET THE SHEET NAMES TO COPY BELOW*
' Array("Sheet Name", "Another sheet name", "And Another"))
' Sheet names go inside quotes, seperated by commas
On Error GoTo ErrCatcher
On Error GoTo 0
' Paste sheets as values
' Remove External Links, Hperlinks and hard-code formulas
' Make sure A1 is selected on all sheets
For Each ws In ActiveWorkbook.Worksheets
Application.CutCopyMode = False
' Remove named ranges
For Each nm In ActiveWorkbook.Names
' Input box to name new file
NewName = InputBox("Please Specify the name of your new workbook", "New Copy")
' Save it with the NewName and in the same directory as original
ActiveWorkbook.SaveCopyAs ThisWorkbook.Path & "\" & NewName & ".xls"
.ScreenUpdating = True
MsgBox "Specified sheets do not exist within this workbook"
After pasting in the above macro, I then ran the code. Ever since running this code, the same 5 documents have been opening every time I open a new or existing Excel file.
I have tried everything in my power to resolve this issue, but unfortunately have had no luck.
Does anyone have an explanation for this happening? IT'S DRIVING ME CRAZY!