Hi
I am having a problem with my personal.xlsb. I have recorded a couple of small macros in there that I use all the time via shortcut keys. These have worked great for ages until now. Initially the just seemed to stop working. After some investigation I found that if I open an existing workbook by double clicking on it in file explorer then personal.xlsb does not open (confirmed in the Visual Basic Window). If I open excel from its shortcut then it loads the personal.xlsb and the macros work fine. I have also found that if I open excel from its shortcut first and then open an existing workbook then the macros work fine. I have searched for a solution to this an found 1 other person having the same problem but it was unresolved. I would appreciate it if anyone could please help me with this.
Thanks
BTW
I am running Excel 2007 SP1 and Windows Vista Business SP2
I am having a problem with my personal.xlsb. I have recorded a couple of small macros in there that I use all the time via shortcut keys. These have worked great for ages until now. Initially the just seemed to stop working. After some investigation I found that if I open an existing workbook by double clicking on it in file explorer then personal.xlsb does not open (confirmed in the Visual Basic Window). If I open excel from its shortcut then it loads the personal.xlsb and the macros work fine. I have also found that if I open excel from its shortcut first and then open an existing workbook then the macros work fine. I have searched for a solution to this an found 1 other person having the same problem but it was unresolved. I would appreciate it if anyone could please help me with this.
Thanks
BTW
I am running Excel 2007 SP1 and Windows Vista Business SP2