E
exploringmacro
Hi, currently I have a macro wherein it save as to new filename, I use the
below and its working.
Application.Dialogs(xlDialogSaveAs).Show
My question is, is there a way to save only the active worksheet instead the
workbook?
EG. I have workbook with sheet1, sheet2 and sheet3. I made a changes to
sheet3 only, is there a way that when I click the save button, it will only
save the sheet 3 instead the entire workbook?
Your help is greatly appreciated.
thanks
below and its working.
Application.Dialogs(xlDialogSaveAs).Show
My question is, is there a way to save only the active worksheet instead the
workbook?
EG. I have workbook with sheet1, sheet2 and sheet3. I made a changes to
sheet3 only, is there a way that when I click the save button, it will only
save the sheet 3 instead the entire workbook?
Your help is greatly appreciated.
thanks