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

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" <(E-Mail Removed)> wrote in message
news:3929B58A-74CD-4B6E-8E26-(E-Mail Removed)...
> 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

On Feb 20, 12:09*pm, tracktraining
<tracktrain...@discussions.microsoft.com> 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

Hi,

Set it in the workbook open event

Private Sub Workbook_Open()
Application.EditDirectlyInCell = True

or

Application.EditDirectlyInCell = False
End Sub


Mike
"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

thanks mike, bob, and matt!
--
Learning


"(E-Mail Removed)" wrote:

> On Feb 20, 12:09 pm, tracktraining
> <tracktrain...@discussions.microsoft.com> 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
>