For those files, Assign this macro to the workbook_open event:
Alt/F11, Ctrl/R, doubkle-click "ThisWorkbook", put in this code:

Private Sub Workbook_Open()
Application.EditDirectlyInCell = False
End Sub


"tracktraining" wrote in message
...
Hi All,

My coworker just tested my file and it didn't work. I soon realized that
the
"edit directly in cell" option was check. So, after unchecking the option,
and the coworker double click on the cell, the userform appears and set
the
userform to be active.

is there a way to have the "edit directly in cell" uncheck for certain
excel
files and check for others without manually having to go to tools/options
everytime?

thanks,
tracktraining
--
Learning