Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Possible Duplicate:
Excel VBA “Unselect” wanted

Is there a way to save a workbook in a state such that when the file is reopened no cell is active (in any of its worksheets)?

share|improve this question
2  
Sorry, but this site is not meant for "useless ... trivia questions". That said, I do see some use for the latter part of your question. More particularly: Is there a way to set a "default view" for a workbook, that is independent of the last "active cell" at the time it was saved? I do find it annoying to open a workbook and find it already pointing to some odd location or sheet, or having some weird filter, that the person working on it previously had just used. –  Iszi Sep 4 '12 at 16:36
2  
There. Hopefully, that edit helps. –  Iszi Sep 4 '12 at 16:39
2  
The question title and the question text have absolutely nothing to do with one another at this point in time. The question title is about "no active cell"; the text is about setting the active cell to a sane default like the first sheet's A1 cell. I don't think either question is trivial or useless, and I don't think we should have edited the OP's question into something other than what was originally asked. However, both questions deserve a legitimate answer. –  allquixotic Sep 4 '12 at 16:50
1  
The original post seemed to be a duplicate of this question: superuser.com/q/469720/76571 –  Excellll Sep 4 '12 at 17:07
1  
@Indrek: I'm well aware of the "XY problem" meme, but as a matter of principle I choose to treat the asker as an adult who knows what he/she wants, and who is perfectly capable, if the situation warrants, of adding to the question remarks like "I'm not sure if this is the right way to solve problem X, feel free to suggest a better approach", etc. Absent such an invitation, attempts to tell me what I "really should be asking" is just condescending and insulting. (BTW, I'm perfectly aware that most of the world sees these matters differently, no need to remind me of it.) –  kjo Sep 4 '12 at 17:14
show 5 more comments

marked as duplicate by Indrek, 8088, Canadian Luke, Randolph West, CharlieRB Sep 6 '12 at 19:42

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

up vote 2 down vote accepted

there is no way to stop selection from occurring. Excel requires the cursor to be positioned somewhere.

The best you can do is to protect the worksheet, and uncheck every item. Selection is still possible, by typing the address directly, but mouse clicks will not work. If you put the cursor in a hidden row and column, it will not be immediately obvious where the cursor actually is

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.