XLA routines: EE_SaveIfMe
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