How to rename workbook that I am editing without saving?

[curiousgeorge408]

I know that I can rename a workbook that I am editing using Save As.

Is there any way to rename it without saving it?

Ideally, a "command". Alternatively, a macro.

After saving a workbook (ctrl-S), I want to "play" with it without
risking overwriting the saved file. I don't want to go to the trouble
of closing it, setting the read-only option on the file, and reopening
it. And I would prefer not to save another copy of the workbook under
a bogus name, which is the only way I know of to change the name (and
the file) of the workbook.

ActiveWorkbook.Name and ActiveWorkbook.ReadOnly both appear to be non-
settable.

 

[Jim Rech]

Is there any way to rename it without saving it?

That's an oxymoron. The name of the file is its name on disk.

To do what you want conveniently though is simple. Customize your toolbars
by dragging the "Toggle Read Only" toolbutton onto one. After that all you
have to do after saving the workbook just click the Toggle button and Excel
will not let you save over it.

This toolbutton is found here: View->Toolbars->Customize. And on the
Commands tab click File and scroll to the bottom of the list on the right.