Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection Grid
Once the following code has been executed - Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim sAddr As String sAddr = "A1:P84" If Not Intersect(Target, Range(sAddr)) Is Nothing Then Cancel = True frmConfig.Show End If End Sub .... the cell that was double clicked remains selected, with a black grid showing. Can this be turned off - by code? Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection Grid
The short answer is no. However, it can be moved to another cell. There
must be an active cell on the active sheet, so there is going to be a cell with a black "grid" somewhere on the sheet. You can pick a cell to move it to and simply use: ChoiceCell.Active With ChoiceCell being replaced with the actual cell reference. "kirkm" wrote: Once the following code has been executed - Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim sAddr As String sAddr = "A1:P84" If Not Intersect(Target, Range(sAddr)) Is Nothing Then Cancel = True frmConfig.Show End If End Sub .... the cell that was double clicked remains selected, with a black grid showing. Can this be turned off - by code? Thanks - Kirk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection Grid
On Sat, 24 Feb 2007 07:03:08 -0800, JLGWhiz
wrote: The short answer is no. However, it can be moved to another cell. There must be an active cell on the active sheet, so there is going to be a cell with a black "grid" somewhere on the sheet. You can pick a cell to move it to and simply use: ChoiceCell.Active With ChoiceCell being replaced with the actual cell reference. That sounds like it'll do nicely. Can you give me a example of usage, please? I tried "A1".Active and variations thereof without getting the right syntax. And no help from F1. Thanks - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - "Snap To Grid" doesn't work on same grid line | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel | |||
I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
grid & grid refrences | New Users to Excel |