Problem
Nothing happens when you double click. There are two reasons for this:
- You double clicked on a cell that doesn’t contain a cell address
- Your security settings prevent macros from running
Solution
With regard to i, to activate the double click feature you must double click on the cell that contains a cell address.
With regard to ii, change your security settings to a lower level:
- Open the Tools menu from Excel’s main menu
- Click on Macro and then on Security …
- When the Security dialog box opens, click on the Security Level tab
- Select a lower security setting
- Click on OK