Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function that returns worksheet name and updates on rename.
I have built a function that reads the name of a worksheet and displays it in
the cell. Once you rename the worksheet, however, the function does not update. Does anyone know how to invoke the updating of this function when the event of renaming the sheet occurs? Also, I would like to use this same function on many different worksheets so it can't look update the functions on all sheets with the name of the one activesheet. Thanks, joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function that returns worksheet name and updates on rename.
Public Function wname()
Application.Volatile wname = Application.Caller.Parent.Name End Function -- Regards, Tom Ogilvy "jr" wrote in message ... I have built a function that reads the name of a worksheet and displays it in the cell. Once you rename the worksheet, however, the function does not update. Does anyone know how to invoke the updating of this function when the event of renaming the sheet occurs? Also, I would like to use this same function on many different worksheets so it can't look update the functions on all sheets with the name of the one activesheet. Thanks, joe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function that returns worksheet name and updates on rename.
It works great. Thanks.
"Tom Ogilvy" wrote: Public Function wname() Application.Volatile wname = Application.Caller.Parent.Name End Function -- Regards, Tom Ogilvy "jr" wrote in message ... I have built a function that reads the name of a worksheet and displays it in the cell. Once you rename the worksheet, however, the function does not update. Does anyone know how to invoke the updating of this function when the event of renaming the sheet occurs? Also, I would like to use this same function on many different worksheets so it can't look update the functions on all sheets with the name of the one activesheet. Thanks, joe |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function that returns worksheet name and updates on rename.
You can do this with worksheet functions:
http://www.mcgimpsey.com/excel/formu..._function.html In article , "jr" wrote: I have built a function that reads the name of a worksheet and displays it in the cell. Once you rename the worksheet, however, the function does not update. Does anyone know how to invoke the updating of this function when the event of renaming the sheet occurs? Also, I would like to use this same function on many different worksheets so it can't look update the functions on all sheets with the name of the one activesheet. Thanks, joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP worksheet function returns zero for empty cells | Excel Worksheet Functions | |||
Function that returns worksheet name? | Excel Worksheet Functions | |||
month worksheet function returns wrong value | Excel Worksheet Functions | |||
Function that Returns Worksheet Name | Excel Discussion (Misc queries) | |||
Is there a function that returns just the worksheet name | Excel Worksheet Functions |