| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last user to make a change
I have the following code at the workbook level of a spreadsheet
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Range("LastChange").Value = Format(Now(), "dd mmm yyyy") Range("LastUser").Value = Environ("username") End Sub I have the named ranges. Why doesn't this work? LWHite |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a picture change based on input from a user? | Excel Discussion (Misc queries) | |||
| User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
| Make Sure User Selects 3 Cells | Excel Programming | |||
| Make a user form 'un-closeable' | Excel Programming | |||
| How to: Make user click End User License Agreement acceptance | Excel Programming | |||
Threaded Mode
