Good afternoon,
Background: I have very entry-level VBA knowledge. Trying to create a macro to copy and paste sheets from a closed workbook to current open and active workbooks. Have macro saved to the personal.xlsb to be able to copy paste sheets from that master workbook to unqiue workbooks I work on throughout the day...would like the masterworkbook to stay closed and hidden and not manipulated throughout the process. My understanding is the designation of ThisWorkbook leads the macro to work on personal.xlsb rather than my open file. How can I correct this?
Background: I have very entry-level VBA knowledge. Trying to create a macro to copy and paste sheets from a closed workbook to current open and active workbooks. Have macro saved to the personal.xlsb to be able to copy paste sheets from that master workbook to unqiue workbooks I work on throughout the day...would like the masterworkbook to stay closed and hidden and not manipulated throughout the process. My understanding is the designation of ThisWorkbook leads the macro to work on personal.xlsb rather than my open file. How can I correct this?