Read Only Workbook - How to Log who reads the workbook
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..
VBAMicrosoft ExcelMicrosoft Office
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!