Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to rename workbook that I am editing without saving?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to rename workbook that I am editing without saving?
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 he View-Toolbars-Customize. And on the Commands tab click File and scroll to the bottom of the list on the right. -- Jim wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS | Excel Discussion (Misc queries) | |||
How to open a new workbook and rename the workbook? | Excel Discussion (Misc queries) | |||
editing and saving worksheet | Excel Discussion (Misc queries) | |||
rename a group of spreadsheets in a workbook | Excel Discussion (Misc queries) | |||
Auto Rename Excel Sheets in Workbook | Excel Worksheet Functions |