I have a macro that has code to close the activeworkbook after a specific task. However, it opens a hidden version of the personal macro workbook immediately after.
Can anyone assist on the why or maybe the vba code should be different?
If closeOption = vbYes Then
ActiveWorkbook.Close SaveChanges:=False
End If
FYI, the Personal Macro Workbook is already hidden so that is not the issue.