#1   Report Post  
Old May 1st 08, 07:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 310
Default 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   Report Post  
Old May 1st 08, 07:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2,836
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating productivity by time Taylor Excel Worksheet Functions 3 February 21st 08 11:34 PM
calculate a productivity percentage Dyson New Users to Excel 1 September 13th 07 08:46 AM
Calculating productivity: widgets per hour ClarkeTeam Excel Worksheet Functions 5 July 10th 07 02:28 AM
How do I make a productivity report? merniewlt Excel Worksheet Functions 0 May 23rd 06 02:46 PM
Quality/ Productivity diagram KrunoG Charts and Charting in Excel 2 January 31st 06 05:55 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017