View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sabre472 Sabre472 is offline
external usenet poster
 
Posts: 1
Default 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.