new workbook tab macro

[Carolina Girl]

Ok this is my thought please let me know if anyone can help… I have a shared
workbook (not by chose) that information has mysteriously been disappearing
on (i.e. some idiot has been deleting it) What I want to do if possible is
ever time someone saves the workbook a copy will be pasted on a new sheet in
another workbook located in a hidden folder. So I would have the master that
everyone is working on and I would have one hidden with the tab with the
user’s name, time and date of when it was saved. Just to make it a little
easer I want all the information on the worksheet to be copied over not just
the changes. I can record a macro to copy and paste into a new workbook but I
have no idea how to add tabs each time with a new name….. HELP PLEASE!!!!!

 

[Otto Moehrbach]

Mike responded to your post but he didn't post it in the same thread. Here
is his post:
For some reason the email address is invalid, so I'm re-posting here.

That's the danger with a shared workbook. If this is your workbook that you
share with others, then I suggest that you make it Read-Only. Others would
need to save it to their pc, make changes to their copy and submit it back
to you to update the master shared workbook. I know it won't be real time
sharing and will entail more work on your end, but which is worse?

Mike F