edit directly in cell
thanks mike, bob, and matt!
--
Learning
" wrote:
On Feb 20, 12:09 pm, tracktraining
wrote:
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
TrackTraining,
This option is the following code in VBA:
Application.EditDirectlyInCell = True (or False)
Look into writing this into a Workbook event (Activate/Deactivate).
Matt
|