PDA

View Full Version : Export Selected Sheets to New workbook



iwelcomesu
02-28-2013, 12:36 AM
Good Afternoon All,

I am unable to find the suitable code for below requirements.

1.I need to select the sheets which I want to export (I will select with Ctrl+Mouse Click)
2. I Need to remove the password protection
3. Delete all unsed empty rows in selected sheets
3. Export used range only as values in new sheet (with selected sheets)

can any guide me with suitable code

Regards,
Hari