-
2 Attachment(s)
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'
Attachment 18030
Seems to run OK under Win10 (64) Office 2016 (32) - if it does what is wanted is another story
-
I am using excel 365 64 bit , and the code no longer works
thanks for the help
-
MS Office UserForms are for local use. Office365 UserForms are for Intra/Inter Net sites.