[dba-Tech] Re: Simple Excel Question

For example on the worksheet you want to do this you add this code
snippet (air code)

Dim oX As Object, X As Object

Sub MyPastLocation()
    oX.Activate
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Set oX = X
        Set X = ActiveCell
End Sub

then in the tool menu go to macros the edit, then select the
MyPastLocation macro and click options and select the hotkey of your
choice. :), happy coding...

Jon Tydda wrote On 6/29/2004 9:25 AM:

>:-(
>
>*chuckle*
>
>
>Jon
>
>-----Original Message-----
>From: Francisco H Tapia [mailto:my.lists at verizon.net]
>Sent: 29 June 2004 17:25
>To: Discussion of Hardware and Software issues
>Subject: Re: [dba-Tech] Re: Simple Excel Question
>
>
>It's a secrete ;o)
>
>Jon Tydda wrote On 6/29/2004 8:28 AM:
>
>  
>
>>oh, how'd you do it?
>>
>>
>>Jon
>>
>>-----Original Message-----
>>From: Arthur Fuller [mailto:artful at rogers.com]
>>Sent: 29 June 2004 15:28
>>To: 'Discussion of Hardware and Software issues'
>>Subject: [dba-Tech] Re: Simple Excel Question
>>
>>
>>Never mind! I figured it out right after clicking "Send".
>>
>>Arthur
>>
>>_______________________________________________
>> 
>>
>>    
>>


-- 
-Francisco