It worked in in previos versions, in Excel 2000, but now, if I a switch in a new workbook, the modeless form dissapear (become inactive) and is not working anymore in any opened workbook.
Is there any solution to fix this?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
VBA Excel Office 365 - how to make a modeless forms show and work in every workbook
0
Answers
0
Hi Jorj and welcome to the Forum
I don't have Office365 but in Excel 2016, you just view the Properties of the UserForm and set the ShowModal property to False.
Revision 1: Also, did you try this instruction (changing the name of the form in bold below)?
UserForm1.Show (VBA.FormShowConstants.vbModal)Please let me know if Excel365 is the same.
Discussion
Hello John and thank you.
No, it's not working, because I want it to run modeless, in any opened workbook, and to work in any active cell or selection.
This problem appear since Office become a multidocument aplication instead a multiwindow (I guess) aplication.
Jorj Feb 23, '21 at 10:21 am
Thanks Jorj, sorry but I can't help you this time.
John_Ru (rep: 6142) Feb 23, '21 at 11:35 am