excel-csvexporter icon indicating copy to clipboard operation
excel-csvexporter copied to clipboard

Published 20 hours ago • verified publisher icon bskinn

Implement machinery to keep form visible after changing Excel windows

Open bskinn opened this issue 6 years ago • 1 comments

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

bskinn avatar Jan 19 '19 04:01 bskinn

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.

bskinn avatar Sep 20 '19 21:09 bskinn