Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
On Opening Excel WB the Active cell location never changes
When I open a certain Excel workbook file the active cell is always at
the same location rather than the location at the last time the file was saved. All of the new information is saved without a problem. This is the only file that I have with which this happens. Is there any way to make it so that when I open the file the active cell is where it was at the time of the last save. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
On Opening Excel WB the Active cell location never changes
Actually, the workbook has to do special stuff to do this kind of stuff. The
common technique would be to have a macro that runs when you open the workbook that selects the specific location. You may want to go back to the developer and ask how to remove this feature. den4673 wrote: When I open a certain Excel workbook file the active cell is always at the same location rather than the location at the last time the file was saved. All of the new information is saved without a problem. This is the only file that I have with which this happens. Is there any way to make it so that when I open the file the active cell is where it was at the time of the last save. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by location within a cell in Excel? | Excel Discussion (Misc queries) | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
compile/syntax error to save active book to new location on networ | Excel Worksheet Functions | |||
How do I shade the active cell in excel | Excel Worksheet Functions | |||
Active Cell when opening workbook | Excel Worksheet Functions |