Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit directly in cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit directly in cell
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit directly in cell
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit directly in cell
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I edit directly in a cell - previously F2 | Excel Discussion (Misc queries) | |||
edit directly in cell - scroll with mouse | Excel Worksheet Functions | |||
edit directly in cell in Excel 2007 | New Users to Excel | |||
Code to edit directly in cells from userform | Excel Programming | |||
Code to edit directly in cells from userform | Excel Programming |