Personal.xlsb

Hello Lisa,

Hope you enjoyed your Microsoft Excel advanced course with Best STL.

Thank you for your question regarding saving macros. Firstly, there are only 3 choices you can make about where to store the macro.

1) Personal Macro Workbook

2) New Workbook

3) This Workbook

The first option allows all files that are opened to use this macro. When you close Excel you are prompted to save changes to the Personal Macro Workbook which is a hidden file and should contain no data, only macros.

It appears as if you have saved the PERSONAL.XLS as a Binary type, whereas, perhaps you should re-save it as a normal .xls workbook.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer