Hi All,

Many thanks for all your suggestions. I will play around with the code
examples and by applying your thoughts & suggestions l am sure l can
now successfully write a solution.

I was referring to the sheet 'codename'

Jon - Your comment worried me, are you saying that if the solution is
distributed with the VBA project protected you cannot change the sheet
'codename' via VBA? If so that totally rules my plan out as l intended
the user to click on macro button to create the sheets from a list
generated by imported data. Currently the sheets names are as per the
imported list and are pretty meaningless so l need to allow the user
to rename to something meaningful. However l need somehow to retain
the original name for various reasons, hence l thought rename the
'codename'. I am not sure that using the index property is going to do
the job. Perhaps l should use a helper cells to 'remember' the
original name but that is a bit of a cop out.

Regards

MB