Hi all,

I have a slight issue that I can't get my head round. I haven't done much of this just a bit of playing in excel.
There is some VBA code on a worksheet that changes the tab colour dependent of some cell values, this works ok.
If I copy and rename the worksheet, the code still changes the tab colour.
But if I use the following code to copy and rename the sheet from a button the code to change the tab stops working.
Please Login or Register  to view this content.
Any ideas??
Thanks