Sorry, you've lost me - you haven't upload anything?
What about the zip file which contains these files?
DEVICE PANEL ORDER.xlsx
Label_Generator ARROWHEAD.xlsm
Module1.bas
Module2.bas
Module3.bas
Module4.bas
Module5.bas
UserForm1.frm
UserForm1.frx
I tried reconstructing the xlsm file but kept on hitting errors, especially after I imported the 5 modules listed above.
By the way, code like this can be reduced by a fair bit if you get rid of all the selecting/activating.
Without activating/selecting.
There also appears to be a pattern in that code which could be used to make the code even shorter.
Bookmarks