Non-modal userform only shows on one workbook

[ByteMarks]

Hi,
I have some code which displays a non-modal userform. Buttons on the userform then allow the user to select ranges from any of the workbooks/sheet in that instance of Excel.

That worked fine before the SDI stuff, but now, even though workbooks are in the same instance of Excel, the form only displays on the workbook it was called from. So it's behaving as if the workbooks are not in the same instance.

Is there any way to have the form stay visible and be able to interact with multiple workbooks?

[ByteMarks]

I've found this which seems to work quite well
https://jkp-ads.com/Articles/keepuserformontop02.asp

Doesn't seem much of an improvement to have to add all that in.

Plus I also found out that SetText/PutInClipboard no longer works: you end up with two question marks when pasting into a cell
A fix is here https://www.thespreadsheetguru.com/b...-the-clipboard
yet another module of code required. Shockingly this seems to have been the case since 2015.