Any computer bods out there willing to give advice?
I was trying to help someone out with an Excel based analytical toolkit which was emailed to me but it doesn;t seem to work on either Excel 2003 or Excel 2007. On Excel 2003 a message comes up saying that the macros will not all work due to it being an older version of Excel, yet my colleague has himself Excel 2003 and it works perfectly for him. When I try it on Excel 2007 a security message comes up but there is no way of reducing the security levels hence it does not work at all. When I work backwards ie from the output sheet there are constant messages coming up saying Visual Basic compile error- hidden module.

When I use a blank spreadsheet it automatically saves it as an xlms file which I understand to be Vista? Yet I don;t have Vista and neither does my colleague. My own system is Windows XP.

I don't suppose this is easy to diagnose remotely but if anyone does have any ideas why this does not work, and why Excel 2007 seems to be a nightmare full stop, please let me know!
My Excel 2007 is from the Office Home and Student Version meant for non commercial use, so I am wondering whether that is part of the problems, or whether there is some incompatibility issue with my own pc , or whether having both the 2003 and 2007 versions installed is causing a problem.

thanks for any information/advice.