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|
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