Hi All
Flummoxed, I am!
I can not right click all lines of my code in the code window.
For example in the below partial extract (with no code running) I CAN right click the line UsrName = Environ("UserName") and get all the usual options. But if I right click Call ConfirmDone("DoneBackup", False) nothing happens.
The same happens whether I'm stepping through code or just viewing it. I have restarted my PC etc.
Anyone ever experienced this?
Thanks for your help in advance,
Tom
Flummoxed, I am!
I can not right click all lines of my code in the code window.
For example in the below partial extract (with no code running) I CAN right click the line UsrName = Environ("UserName") and get all the usual options. But if I right click Call ConfirmDone("DoneBackup", False) nothing happens.
The same happens whether I'm stepping through code or just viewing it. I have restarted my PC etc.
Anyone ever experienced this?
Thanks for your help in advance,
Tom
Code:
Call ConfirmDone("DoneCompactDB", False)
Call ConfirmDone("DoneBackup", False)
Call ConfirmDone("DoneChkLs", False)
Call ConfirmDone("DoneCheckLoadStatus", False)
End If
End With
End Sub
Sub ConfirmDone(RangeRoot As String, ShowAsDone As Boolean)
Dim UsrName As String
Dim DoneTime As String
If ShowAsDone Then
UsrName = Environ("UserName")
DoneTime = "'" & CStr(Format(DateTime.Now, "dd-mmm-yy hh:mm:ss"))
Else