I need to create a macro that will allow me to export two sheets at a time from my current workbook to a new workbook and password protect it.
ex.
current workbook
sheet1, ads,dr,hr, ...ect
export:
sheet1, ads then sheet1,dr then sheet1,hr ...ect
each to a new file with name corresponding to the second sheet exported.
ex.
sheet1, ads
filename: ads.xls
and have it password protected.
thanks
ex.
current workbook
sheet1, ads,dr,hr, ...ect
export:
sheet1, ads then sheet1,dr then sheet1,hr ...ect
each to a new file with name corresponding to the second sheet exported.
ex.
sheet1, ads
filename: ads.xls
and have it password protected.
thanks