Hello,
Here is my issue...
I would like the click of a button on userform to do the following...
Copy all sheets from current workbook to a new workbook and save as a new name. The sheet names need to stay the same. I've found a lot of code to do this (as i'm not really a big vba programmer) but haven't found something that works.
As well as this I would like to actually only copy a range of each worksheet rather then entire sheet....there is a row (H) that needs to not be visible to the recipient of the workbook but the rest of the data can be seen. I'm not sure if copying a range works best or deleting all Column H in all sheets. I'd like also to not include any code with the new workbook.
Please can someone help point me in a right direction.
Thank you.
Here is my issue...
I would like the click of a button on userform to do the following...
Copy all sheets from current workbook to a new workbook and save as a new name. The sheet names need to stay the same. I've found a lot of code to do this (as i'm not really a big vba programmer) but haven't found something that works.
As well as this I would like to actually only copy a range of each worksheet rather then entire sheet....there is a row (H) that needs to not be visible to the recipient of the workbook but the rest of the data can be seen. I'm not sure if copying a range works best or deleting all Column H in all sheets. I'd like also to not include any code with the new workbook.
Please can someone help point me in a right direction.
Thank you.
