Thanks, Paul. That is possible, though I finally, after many attempts, managed to get the repaired copy open. The repair removes two ActiveX buttons. Perhaps I should use form buttons on the sheet and send the macro to the VBA? Anyway, on the repaired copy I see what had worked is this...
    Set wks = Sheets("Security")    With wks
        Set Mycell = Cells(wks.Range("AdmUsrCk").Value, UserCol)
That had worked... though I can see that Sheet17.Cells(Range... makes sense. Not sure how it relates to the problem of writing to the wrong sheet. By the way, AdmUsrCk is the named range of a single cell on Sheet17 (Security). It contains this formula.. =IFERROR(MATCH(B5,UserName,0)+4,"") B5 is linked to the frmLogin UserName that was just entered by a user.

I have a side question this morning. Since I finally opened the file, before I close it... I already exported each VBA Excel object and module. My practice was to Copy/Paste to Notepad, which only allows text, and then Copy/Paste back to the VBA. I heard somewhere that the Export, Import can get rid of issues that Excel generates behind the code... good to clean it up and start fresh. I am guessing I would need to delete the VBA after export, then save and close the spreadsheet, then open it and import the VBA. Is that correct? Do I need to also copy paste from spreadsheet to new spreadsheet? I would think the spreadsheets should be good as is, No?

Gary