Hi Nigel,

The way the worksheet is
setup means I would rather not just delete the whole sheet and replace
it with one stored as a template which is what the microsoft knowledge
base suggests.

If the template sheet (workbook?) shows the blank form exactly as you want
it, the suggested approach would seem to present few problems.

Why would this appoach not appeal?

---
Regards,
Norman



"Nigel" wrote in message
...

Hi

I have a small excel estimate form which needs to be able to expand to
accomodate extra information when required. When finished I simply
print the form off and want to return the form back to its original
size with all the entered data removed. I recorded a macro which
deleted the form and pasted in its place a copy of the original stored
on a different worksheet. Worked great untill I tried to share
it.........now I get "run time error 1004" The way the worksheet is
setup means I would rather not just delete the whole sheet and replace
it with one stored as a template which is what the microsoft knowledge
base suggests. If anybody has any ideas I would be grateful..........to
date my ability to compile macros is limited to the "record" function
but im happy to have a go if someone can point me in the right
direction.

Many thanks


--
Nigel
------------------------------------------------------------------------
Nigel's Profile:
http://www.excelforum.com/member.php...o&userid=25696
View this thread: http://www.excelforum.com/showthread...hreadid=391122