| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i save file to show current worksheet
I have a multi-spreadsheet workbook which I share with other users. When I
save and close in one spreadsheet (ie this week's) and then re-open, it doesn't take me back to where I was when I saved it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i save file to show current worksheet
Hi,
It should take you back to the worksheet and cell that were active when saved and if it doesn't then a macro is redirecting it. Alt +F11 to open VB editor and double click 'This workbook' and see if there are any macros redirecting the workbook to open on a certain sheet. Mike "Hatleydell" wrote: I have a multi-spreadsheet workbook which I share with other users. When I save and close in one spreadsheet (ie this week's) and then re-open, it doesn't take me back to where I was when I saved it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i save file to show current worksheet
Hi,
It should open to wherever the active cell was when it was last saved. HTH Martin "Hatleydell" wrote in message ... I have a multi-spreadsheet workbook which I share with other users. When I save and close in one spreadsheet (ie this week's) and then re-open, it doesn't take me back to where I was when I saved it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I show the current file name in a cell. | Excel Worksheet Functions | |||
| Save current sheet to new file | Excel Discussion (Misc queries) | |||
| I can't insert a worksheet into my current spreadsheet file | Excel Worksheet Functions | |||
| 'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
| How to save the current worksheet as JPEG, TIFF or DICOM? | Excel Worksheet Functions | |||
Linear Mode
