Automatic Worksheet Calculation when Worksheet Name Changes

[Sabre472]

All,

I have some VB functions that are called on one Worksheet. The functions
reference the Worksheet's name. The Worksheet starts as a "prototype".

I copy, then change the name of the "prototype".

Once renamed, I want the functions to recalculate automatically.

 

[Bernie Deitrick]

If you are calling the function from a cell, instead of using

Worksheets("prototype")

use

Application.Caller.Parent


If you are using the Function in VBA, then perhaps, use

ActiveSheet

instead.

HTH,
Bernie
MS Excel MVP