Mike wrote:

Access the code by using the VB editor (Tools - Macro - VB Editor). If the
userform hasn't terminated its a good idea to do this first

When I terminate the userform it closes the whole spreadsheet therefore
I can't get to the editor that way unfortunately. I can open the
editor when I start excel without opening any specific spreadsheet but
then my code is, of course, unavailable as I don't have my xls open.
See what I mean?

This has GOT to be an easy one.... I thought....hehe