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)?
|show 5 more comments|
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.
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