I doubt you can, but you can make the action not visible
Application.ScreenUpdating = False
worksheets(worksheets.count).Copy
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "C:\myfolder\myfile.xls"
Application.DisplayAlerts = True
ActiveWorkbook.Close SaveChanges:=False
Application.ScreenUpdating = True
--
Regards,
Tom Ogilvy
"sp00nix " wrote in message
...
I would like to export the last worksheet in my workbook into a backup
dir. How can I do this without doing "Copy Worksheet" where it opens up
in the new work book? I would just like it to export while keeping only
the current workbook open.
Thanks in advance,
Mike
---
Message posted from http://www.ExcelForum.com/