Productivity
 

A collegue of mine who is now gone setup a function that I would double-click
on a cell and it would automatically go to the cells that were referenced in
the cell. The default only does it in the current tab, this "extra" option he
setup allowed that to happen even it was on a different tab or in a different
file. If it was in a different file, the file would launch and the cell or
cells would be highlighted. Please helppppp

Productivity
 

You must have event code in the sheet module. Right-click on the tab of the
sheet that works for you. A window will open wand you will see the code that
runs when you double-click the cells in the sheet. Copy and paste that code
into the other sheets (by right-clicking on each sheet and pasting that same
code into each window that opens).


Regards,
Ryan--

--
RyGuy


"Michelle" wrote:

A collegue of mine who is now gone setup a function that I would double-click
on a cell and it would automatically go to the cells that were referenced in
the cell. The default only does it in the current tab, this "extra" option he
setup allowed that to happen even it was on a different tab or in a different
file. If it was in a different file, the file would launch and the cell or
cells would be highlighted. Please helppppp