Copy sheet over another one - Excel

[LKB6]

How can i program VBA to copy an existing sheet used as template over another sheet?
Thanks in advance.

 

[SkipVought]

Hi,

Turn on your macro recorder and record doing what you want to do.

Post back with your recorded code if you need help customizing.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[LKB6]

Thank,
But is there any code I could put in the VBA to do this automatically each time I start the spreadsheet.
The reason is that I need to wipe out all previous calculations made on each sheets and refresh with a new template page.

 

[PHV]

You may use the Workbook_Open event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

One step at a time, grasshopper.

Where is your code?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]