The following procedures allow to keep all components of one Workbook in synch with those in another one provided the component in the source Workbook exists in the target Workbook. All component's code is transferred by line with the exception of UserForms which are transferred via Export/Import in order to synchronize also a UserForm's design.
Note: The used module "mExists" can be found here.
Copy the below into a standard module and don't forget the required references.
![]()
Please Login or Register to view this content.
Bookmarks