View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Finny[_3_] Finny[_3_] is offline
external usenet poster
 
Posts: 49
Default personal2.xls appears and now all my triggers point to it

I fixed it!
With Excel closed, I renamed Personal2.xls to Personal2.xls.bak.
I thought Excel would now only pick up personal.xls and have a lot of
orphaned shortcuts to personal2.xls.
When I got back into the vba editor, it was still there - with the bak
extension! What Excel is using to identify this as a workbook i do not
know.
So from there it was easy. Close excel, move my good Personal.xls to
another folder, rename Personal2.xls.bak to Personal.xls and open
Excel again. All my shortcuts are back to my original personal.xls
again! phew!
Then close excel, copy my good personal.xls over the bad and bada
bing.
back to normal.
just in time for the weekend!
Thanks for the input Dave,
Finny