Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
bskinn opened this issue Jan 19, 2019 · 1 comment
Open

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

bskinn opened this issue Jan 19, 2019 · 1 comment
Labels
bug
Milestone
Sooner

Comments

@bskinn
Copy link
Owner

bskinn commented Jan 19, 2019

Depends on whether the SheetActivate event is triggered on a workbook focus change. Might not be.
@bskinn bskinn added this to the Sooner milestone Jan 19, 2019
@bskinn
Copy link
Owner Author

bskinn commented Sep 20, 2019

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 bskinn modified the milestones: Sooner, v1.2 Sep 20, 2019
@bskinn bskinn changed the title Check whether 'range to export' update machinery is triggered on work*book* change Implement machinery to keep form visible after changing Excel windows Sep 20, 2019
@bskinn bskinn added bug and removed question labels Sep 20, 2019
@bskinn bskinn modified the milestones: v1.2, Sooner Jan 18, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
Sooner
Development

No branches or pull requests
1 participant
@bskinn