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.
Quote:
|
I am trying to write a macro to automate a process that happens every day.
|
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.