You could certainly adapt the routine he

http://mcgimpsey.com/excel/events/sh...efromcell.html

In article ,
santaviga wrote:

Is there a fast way to rename sheets as per a cell on a worksheet?

Cell A2 Pay

Link this cell so that it call Sheet 2 Pay.

Regards