I would like to combine two workbooks but besides macros, they both have
userforms with the same name (eg userform1). How do I prepare the
workbooks before combining so that the userforms with the same
designation/name do not overwrite each other. I tried changing the
userform name and caption (in userform properties) but the macros that
called the userform did not like that (even if I changed the name in the
call procedure)