I am very green at VBA and are in need of a little guidance and code support.
I need code that will allow a user to start a macro on a button click that will then take only one of the worksheet from the workbook called Pricing Template. It would then ask the user to give it a new name and file location. With this it would then transfer only the one worksheet and close out all open workbooks.
Any support would be greatly appreciated. I am using Excel 2007
KH
I need code that will allow a user to start a macro on a button click that will then take only one of the worksheet from the workbook called Pricing Template. It would then ask the user to give it a new name and file location. With this it would then transfer only the one worksheet and close out all open workbooks.
Any support would be greatly appreciated. I am using Excel 2007
KH
