search

bskinn / excel-csvexporter

Lightweight tool to export ranges within an Excel sheet to CSV
MIT License
41 stars 7 forks source link

Implement machinery to keep form visible after changing Excel windows #20

Open bskinn opened 5 years ago

bskinn commented 5 years ago

Depends on whether the SheetActivate event is triggered on a workbook focus change. Might not be.

bskinn commented 5 years ago

In Excel 2019, the userform does not 'transfer' to a new workbook when focus changes; it must be re-displayed atop the new window. Need to trigger this redisplay, if possible.

A quick attempt based on the WindowActivate event worked... sort of.