Automatic Worksheet Calculation when Worksheet Name Changes
 

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.

Automatic Worksheet Calculation when Worksheet Name Changes
 

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


"Sabre472" wrote in message
...
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.