Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Default Save As for Single worksheet
Hi
can anybody help - i need to change the default save as - im on exel 2000 - but i only want it to save on the current workbook and not every excel workbook. Does anyone have any ideas please. many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Default Save As for Single worksheet
I don't think you can.
But you could use a macro that automates the copying, saving, and closing that does it for you. With hardly any testing or validity checks: Option Explicit Sub testme() Dim res As Long ActiveSheet.Copy 'to a new workbook res = Application.Dialogs(xlDialogSaveAs).Show If res = 0 Then MsgBox "Not saved" Else MsgBox "Saved" End If ActiveSheet.Parent.Close savechanges:=False End Sub Pammi J wrote: Hi can anybody help - i need to change the default save as - im on exel 2000 - but i only want it to save on the current workbook and not every excel workbook. Does anyone have any ideas please. many thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change default font for single workbook | Excel Discussion (Misc queries) | |||
default save directory for a templated worksheet | New Users to Excel | |||
How do we Extract/Save a single worksheet out of a Mutlipage workb | Excel Discussion (Misc queries) | |||
Save a single worksheet in Excel as a single file. | New Users to Excel | |||
Change worksheet radian default | Excel Discussion (Misc queries) |