| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if a workboo has been saved
I trying to have a macro auto exceute to put the user name in a cell on a
worksheet each time the workbook is saved Does anyone know how to do this? -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine if a workboo has been saved
Hi,
Alt+F11 to open VB editor. Double click 'this workbook' and paste this in on the right Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("Sheet1").Range("a1").Value = Environ("Username") End Sub Mike "QuietMan" wrote: I trying to have a macro auto exceute to put the user name in a cell on a worksheet each time the workbook is saved Does anyone know how to do this? -- Helping Is always a good thing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine if a workboo has been saved
Your description does not match your subject line but maybe........
Private Sub Workbook_BeforeSave(ByVal SaveAsUI _ As Boolean, Cancel As Boolean) Sheets("Sheet1").Range("A1").Value = "Last Saved By " & Environ("UserName") End Sub Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 12:45:02 -0700, QuietMan wrote: I trying to have a macro auto exceute to put the user name in a cell on a worksheet each time the workbook is saved Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I recover an Excel document saved not saved as | Excel Discussion (Misc queries) | |||
| Determine whether the user has saved the file? | Excel Programming | |||
| can i put a password on a folder rather than on each excel workboo | Excel Discussion (Misc queries) | |||
| Going back from a hyperlink when it has changed to another workboo | Excel Discussion (Misc queries) | |||
| Determine if XL file opened from Outlook or a saved file | Excel Programming | |||
Linear Mode
