Hi,
I've written a macro that imports data from a master spreadsheet into a second workbook. This workbook is then shared with entities outside the organisation for which I work.
The data is imported to worksheet1. There's a static worksheet of unchanging contact data we'll call worksheet2, and there's a third worksheet containing buttons that activate the import macro and cells that contain important filepaths called workbook3.
It wouldn't be wise to allow third parties to view the third worksheet containing macros and filepaths. So, I'm wondering if there's code I can use that will copy worksheet1 and worksheet 2 to a new workbook once the import is complete, without copying the code.
Thanking you in advance!
I've written a macro that imports data from a master spreadsheet into a second workbook. This workbook is then shared with entities outside the organisation for which I work.
The data is imported to worksheet1. There's a static worksheet of unchanging contact data we'll call worksheet2, and there's a third worksheet containing buttons that activate the import macro and cells that contain important filepaths called workbook3.
It wouldn't be wise to allow third parties to view the third worksheet containing macros and filepaths. So, I'm wondering if there's code I can use that will copy worksheet1 and worksheet 2 to a new workbook once the import is complete, without copying the code.
Thanking you in advance!