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.