|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 13th, 2005, 09:50 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Update workbook each time a different worksheet is selected
I need to update a workbook each time the user goes to a new worksheet either
by selecting the tab for that worksheet or by hyperlink. How can I to this without using a macro? (using macro is ok if necessary but I am trying to keep things simple) 
|
|
#2
December 13th, 2005, 10:20 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Update workbook each time a different worksheet is selected
DJ
"Update" means what? More details please. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:50:02 -0800, DJL wrote: I need to update a workbook each time the user goes to a new worksheet either by selecting the tab for that worksheet or by hyperlink. How can I to this without using a macro? (using macro is ok if necessary but I am trying to keep things simple)
|
|
#3
December 15th, 2005, 01:45 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Update workbook each time a different worksheet is selected
This does what I need.
=VALUE(REPLACE((MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)),1,1," ")) Where the names are W1, W2, Wn and all I need is the numeric part of the tab name. This was adapted from what I found on this web site: http://www.mcgimpsey.com/excel/formu..._function.html "Gord Dibben" wrote: DJ "Update" means what? More details please. Gord Dibben Excel MVP On Tue, 13 Dec 2005 13:50:02 -0800, DJL wrote: I need to update a workbook each time the user goes to a new worksheet either by selecting the tab for that worksheet or by hyperlink. How can I to this without using a macro? (using macro is ok if necessary but I am trying to keep things simple)
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| workbook update each time a new worksheet is selected | DJL | New Users | 3 | December 15th, 2005 01:48 PM |
| Same Worksheet Opens Every Time Workbook is opened | rmm30 | Charts and Charting | 6 | September 21st, 2004 06:32 PM |
| Same Worksheet Opens Every Time Workbook is opened | rmm30 | Charts and Charting | 1 | September 20th, 2004 11:48 PM |
| Workbook with big array functions slow to open first time in 2003 | Terry | General Discussion | 1 | September 2nd, 2004 05:00 PM |
| Sheet Names | Joseph M. Yonek | Worksheet Functions | 6 | January 3rd, 2004 02:15 AM |
Linear Mode
