Corrie80405
Q: Why there is Workbook_BeforeClose with UserForm-code?
... which has code
... anyway, I would use that code
in ThisWorkbook ... Workbook_BeforeClose ... is empty?
Only Sheet2-sheet seems to try to hide and show
... other sheets
... hmm? ... one-by-one select ... but why?