Thread: Save and rename
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Save and rename

Only by using code to save as a different name then deleting the original.

What name would you like to "Save As"?

Is there a value in a cell or somesuch?


Gord Dibben MS Excel MVP

On Wed, 25 Feb 2009 13:14:34 -0800, Steve
wrote:

I often want to save a workbook and rename it and wonder if there's a single
step solution. I know I can do a save and then go into the windows explorer
and rename the workbook. Or I can do a save as and then go to windows
explorer and delete the previous version. It would be nice if there was a
way to do it all within excel in a single step.