In the meantime maybe this will help. When the sheet is activated the letter a is put in D6:

this goes in the code module for the sheet.
 
Private Sub Worksheet_Activate()
    Range("D6").Value = "a"
End Sub
It could be put in workbook open in the thisworkbook module if that would be better.....