Hello Bob,

I would suspect if you right click the tab of the sheet containing the “Grand_Total and “Grand_Total” cell that you double click,
then click View Code,
the sheet module that opens would contain a
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) event procedure.
If so, you should post it so we have something to work with.

Sounds like the perfect opportunity to use Excels' built in macro recorder to record the daily process.
Posting this would also be of great help towards getting assistance.