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
Bookmarks