XLA routines: EE_SaveIfMe

Nick's picture
EE_SaveIfMe is a handy developer sub that saves your work if you are the one running it. - it does not save if someone else is running it - never lose your work to crashes in Excel again !
Sub EE_SaveIfMe(strUserName As String)
'Takes a username as string
'Looks to see if application.username or ee_getusername is the string..
'If yes, save the workbook.

'http://excelexperts.com/xla-routines-eeSaveIfMe    for updates on this sub routine

    Select Case strUserName
    Case Application.UserName, EE_GetUsername
        ThisWorkbook.Save
    End Select
End Sub