Hi all

Apologies if this is already covered somewhere on the huge forum, but i was not able to find it.

I am using Excel 2007, so I have created an Personal.xlsb file in C:\Users\<users>\AppData\Roaming\Microsoft\Excel\XLSTART by recording a macro

I have it set to 'not hidden' so I can see if it opens.

If I go into Start\Excel then personal.xlsb opens sucessfully

If I open any xls, xlsm, xlsx file via a shortcut to the actual document, then personal.xlsb does not open.

It is not disabled in the add-ins menu (as all of the solutions I have found so far mention)
I have deleted and re-created the personal.xlsb file
I have tried .xls, .xlsa, .xlsb - All of these work via start menu and do not work via shortcuts
I can always open my personal.xlsb file directly

Any ideas anyone?

I really really would like to get this working asap

Many thanks all

Gary