I have a Ready Only workbook that is available to 100 people. I want to determine who uses the workbook. However, I can not add code to the OnOpen event as since the Workbook is read only then my code can not write the users name to a cell. My other concern is a macro may open this read only workbook and I do not want to impact any macros that may open this read only workbook and extract info..
Any suggestions on how I can figure out who uses the workbook without having to email all 100 individuals..