Hello,

You are using two sections of excel.

open the both files at the same section and it will works

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"stew" escreveu:

Hi all
I have done this a 1000 times but now its not Doing it Properly!!
Copy one Work sheet with Formula to new work book.

It copies only values and not Formula and is not giving me an option to
paste the formula

Original Sheet Not protected

Excel 2003.

Put me right please

Best

Stew