ExcelVBA SetSameView
1.0.0
If you show again without unloading the Form, the ActiveWorkBook that was first shown will be displayed all over.
However, the ActiveWorkBook observed from VBA becomes the ActiveWorkBook just before it shows. *
It's like a specification or a bug in Excel.
So, when the operation is finished, Unload Form.
*
In Excel 2013, if you display the UserForm from another book, the Active book will be cut off.
https://answers.microsoft.com/ja-jp/msoffice/forum/all/excel2013%E3%81%A7%E3%81%AFuserform%E3%82%92/0a9b304b-309c-4b8a-96a5-180b9ba9c93c
