I have a long macro in my personal that I would like to put into our departmental add in so my colleagues can easily use it.
do I need to put activeworkbook. before all my worksheets("") and Range("") references and can I take away all of the workbook("addin.xlam") references in my codes before doing so or does excel run all add in scripts in the active workbook environment by default?