If there is, I bet it would be difficult to find.
But if you want a workbook that starts off with certain data already in it, you
may want to consider creating a template -- and saving it into your template
folder.
Then when you do file|new, you can point at that template and you'll have that
predefined data already there.
As for the save, you could use a worksheet event that adds your data.
If you give more information, I'm sure someone will jump in with some
assistance.
nc wrote:
Is there a internet link of an example of a macro for
entering multiple rows data when pressing a save/new
button once?
Thanks.
--
Dave Peterson
|