Make userform stay on top of all windows when macro is fired

[Paul_Hossler]

OP is running Win7 Ultimate 64 bit (Post #15) with 32 bit Office (assuming from Post #17)

I added Option Explicit to Leith's workbook's -- Rem ver 32 bit.xlsb (Post #16) -- including the UserForm1, fixed some undefined references and changed Global to Public


Largest issue (and the one causing the 424 - Object Required error message - was in the initialization for the Userform1 since there was no module named 'Keep_Form_On_Top'

Capture.JPG


Seems to run OK under Win10 (64) Office 2016 (32) - if it does what is wanted is another story

[Bugs]

I am using excel 365 64 bit , and the code no longer works

thanks for the help

[SamT]

MS Office UserForms are for local use. Office365 UserForms are for Intra/Inter Net sites.