I'm running some code in a module and then removing the module using
ThisWorkBook.VBProject.VBComponents.Remove etc. I then save the file
using ThisWorkBook.Save. However, if I dont save the file on closing
when prompted by excel then when I reopen the file the module is still
there!! What am I doing wrong?? (The module is removed if I save at the
excel prompt.)