| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Workbook
On Aug 11, 8:40*pm, eliano wrote:
On 12 Ago, 02:27, Slim Slender wrote: Here's something I can't figure out. If I run this by double-clicking in an empty cell, it enters the username then stays in edit mode with the cursor flashing in the cell. When I *duoble click on a cell that has something in it, the program does what it is supposed to do and skips down to an empty cell and enters the username and "finishes", the cursor not flashing. I would like to have them both "finish". How is that controlled? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) * * If Target.Column = 3 Then * * * * Do * * * * * * If Selection.Value < "" Then * * * * * * * * Selection.Offset(1, 0).Select * * * * * * End If * * * * Loop Until Selection.Value = "" * * * * Selection.Value = Environ("username") * * End If End Sub Hi Slim. Probably, due to my poor english, I have not understood. However try to insert the instruction: Cancel = True as first instruction in the macro. Regards Eliano- Hide quoted text - - Show quoted text - Thanks Eliano, that works. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shared workbook is set up is not 'shared' on network | Excel Worksheet Functions | |||
| shared workbook - shared workbook options grayed out | Excel Discussion (Misc queries) | |||
| Shared Workbook - Slow opening of shared workbook. | Excel Programming | |||
| Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
| update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
![Slim Slender[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
