| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new workbook tab macro
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 users 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!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saving macro from workbook to Personal Macro Workbook | Excel Discussion (Misc queries) | |||
| How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from? | Excel Programming | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please | Excel Programming | |||
Threaded Mode
