BobBridges
Active Member
For a few years now I've been running my time sheet in Excel 2010 under Win 7, but I recently switched to a new PC with Win 10 and Excel 2019 and its behavior has changed in a minor but annoying way. I'm hoping someone can tell me how to fix it.
When I begin or end work on a project, I double-click on a cell; the BeforeDoubleClick code for that worksheet puts into that cell either the current time or an Excel formula, depending on the circumstances. Under Win 7 and Excel 2010 that worked as you might expect: I'd double-click on a cell and the value 16:38 (for example) would appear in the cell.
Under Win 10 and Excel 2019, however, what appears is "16:38:00" and the cell is left in data-entry mode (as though I'd hit <F2>); the value is displayed, but I have to hit <Enter> manually to continue. It's a small thing to hit <Enter>, but I do it many time per day and I didn't use to have to do that. Does anyone know what's changed, and what I need to do to get back to normal?
(The actual value being plugged in is 0.693055555555556, if that matters. I suppose it doesn't.)
When I begin or end work on a project, I double-click on a cell; the BeforeDoubleClick code for that worksheet puts into that cell either the current time or an Excel formula, depending on the circumstances. Under Win 7 and Excel 2010 that worked as you might expect: I'd double-click on a cell and the value 16:38 (for example) would appear in the cell.
Under Win 10 and Excel 2019, however, what appears is "16:38:00" and the cell is left in data-entry mode (as though I'd hit <F2>); the value is displayed, but I have to hit <Enter> manually to continue. It's a small thing to hit <Enter>, but I do it many time per day and I didn't use to have to do that. Does anyone know what's changed, and what I need to do to get back to normal?
(The actual value being plugged in is 0.693055555555556, if that matters. I suppose it doesn't.)