Hello experts,
I have a procedure that copy the UserForm "ABC" and the respective modules to Workbook A from the other workbook B(each time I open Workbook A) and I am able to delete the modules and the UserForm remains in Worksheet A(Which should not). So can someone please suggest me how to delete the UserForm "ABC" when I am closing the workbook A.
And each time I open the workbook A, I am noticing blank "Class Modules" are created and these blank class Modules are getting increased for every time I open the workbook A.
Can anyone suggest me how to delete the UserForm and blank Class Modules? or is there any way to avoid the blank Class Modules getting created?
I have a procedure that copy the UserForm "ABC" and the respective modules to Workbook A from the other workbook B(each time I open Workbook A) and I am able to delete the modules and the UserForm remains in Worksheet A(Which should not). So can someone please suggest me how to delete the UserForm "ABC" when I am closing the workbook A.
And each time I open the workbook A, I am noticing blank "Class Modules" are created and these blank class Modules are getting increased for every time I open the workbook A.
Can anyone suggest me how to delete the UserForm and blank Class Modules? or is there any way to avoid the blank Class Modules getting created?
