I created a macro and where you get the option to save to macros, drop down
list includes to "All open workbooks", This workbook, I have somehow created
another called personal, so whenever I open a new excel workbook, it's
immediately called persona, and whenever I open an existing workbook,
personal worksheet is there also, how do I undo this?
The Personal workbook is generally stored in the XLSTART folder and
automatically opens with Excel but is normally hidden
Seems you have such a file and have made it your default
best wishes