Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating productivity by time | Excel Worksheet Functions | |||
calculate a productivity percentage | New Users to Excel | |||
Calculating productivity: widgets per hour | Excel Worksheet Functions | |||
How do I make a productivity report? | Excel Worksheet Functions | |||
Quality/ Productivity diagram | Charts and Charting in Excel |