Update workbook each time a different worksheet is selected

[DJL]

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)

 

[Gord Dibben]

DJ

"Update" means what?

More details please.


Gord Dibben Excel MVP

 

[DJL]

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/formulae/cell_function.html