Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |