Trouble with Sheet programming

[dilexcel]

I only have basic skills in excel and am currently trying to find a ne
way to improve an exsiting excel file. It is a file that needs to b
updated often and I seem to be having to edit the formatting ever
time.

I want to know if it is possible to have each page automatically defaul
to a new sheet and have the sheet named Page 1 for page 1, page 2 fo
page 2 etc.

I have made a template of the main formatting I want for each sheet an
I want it to stay the same for each sheet and not be able to be modifie
as I add data.

I apologise I am not very skilled in this area and struggle wit
formulas and have not used a forum before.

Please let mw know if you have any suggestions.

Much appreciated

 

[GS]

One way would be to use SaveAs and save the file with a new name
whenever you want to start fresh, then just clear any existing data so
the formatting remains intact. With VBA, this could be automated!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion