Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
First save to save as
"The first time you save a workbook, use the SaveAs method to specify a name for the file." I have my save and save as buttons working I just need to know how to make it so that if I press the "Save" button before I do "Save As..." it will automatically point to the "Save As..." code Thanks for any help!! :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
First save to save as
Hi Check the "Saved" property, like this: If ThisWorkbook.Saved = False Then 'Use SaveAs Else 'Use save End If Regards, Per "Shadow24" skrev i meddelelsen ... "The first time you save a workbook, use the SaveAs method to specify a name for the file." I have my save and save as buttons working I just need to know how to make it so that if I press the "Save" button before I do "Save As..." it will automatically point to the "Save As..." code Thanks for any help!! :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
First save to save as
Ok thanks!! :) "Per Jessen" wrote: Hi Check the "Saved" property, like this: If ThisWorkbook.Saved = False Then 'Use SaveAs Else 'Use save End If Regards, Per "Shadow24" skrev i meddelelsen ... "The first time you save a workbook, use the SaveAs method to specify a name for the file." I have my save and save as buttons working I just need to know how to make it so that if I press the "Save" button before I do "Save As..." it will automatically point to the "Save As..." code Thanks for any help!! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
Disable save, save as, but allow save via command button | Excel Programming | |||
How to diasble save and save as menu but allow a save button | Excel Programming | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming |