Thank you for looking at my question,
I have a macro-enabled .xlsm file - SPI.xlsm. Whilst making a minor change to the vba code behind it I managed to duplicate the declaration of a string variable.
Not fully paying attention to what I was doing I OK'd the warning message, closed the vba window and the xlsm file.
Now the file won't open, just hangs. There is an instance of Excel running in task manager processes and if I try to open the file again it tells me that the file is already open and locked for editing by me.
Please can anybody advise me how I can open this file / get to the vba code behind it again so that I can rectify the mistake?
Thank you in advance for your help