From: Mike Wheeler on 27 Mar 2010 13:52 I have NO clue how this is done, or even if it is an excel command... But I have a spreadsheet that work has sent me that if I double click on any cell in the A column, it captures that cell data and sends it to another window then does an Enter command. I have looked all through the spreadsheet and I can't find any macro at all, or anything that might do this. I doubt it is another application because I setup another spreadsheet to mimic it, and it will not do it, so it has to be tied to that spreadsheet somehow. Does anyone have any clue how this works, or if it is not excel, what might do this? I am running MS Office 2007 on an XP machine. The only windows open are Outlook, two web browsers and one excel spreadsheet. Thoughts?
From: Mike H on 27 Mar 2010 15:12 Hi, Have you checked for 'Event' code? Right click the 'offending' sheet tab, view code and have a look in there on the right. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mike Wheeler" wrote: > I have NO clue how this is done, or even if it is an excel command... > > But I have a spreadsheet that work has sent me that if I double click on any > cell in the A column, it captures that cell data and sends it to another > window then does an Enter command. > > I have looked all through the spreadsheet and I can't find any macro at all, > or anything that might do this. I doubt it is another application because I > setup another spreadsheet to mimic it, and it will not do it, so it has to be > tied to that spreadsheet somehow. > > Does anyone have any clue how this works, or if it is not excel, what might > do this? > > I am running MS Office 2007 on an XP machine. The only windows open are > Outlook, two web browsers and one excel spreadsheet. > > Thoughts?
From: Mike Wheeler on 29 Mar 2010 10:33 YOU DA MAN!!! Mike H, once again you don't let me down. Thanks boss! I found the code right where you said. I never thought to look there! *dances* "Mike H" wrote: > Hi, > > Have you checked for 'Event' code? Right click the 'offending' sheet tab, > view code and have a look in there on the right. > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Mike Wheeler" wrote: > > > I have NO clue how this is done, or even if it is an excel command... > > > > But I have a spreadsheet that work has sent me that if I double click on any > > cell in the A column, it captures that cell data and sends it to another > > window then does an Enter command. > > > > I have looked all through the spreadsheet and I can't find any macro at all, > > or anything that might do this. I doubt it is another application because I > > setup another spreadsheet to mimic it, and it will not do it, so it has to be > > tied to that spreadsheet somehow. > > > > Does anyone have any clue how this works, or if it is not excel, what might > > do this? > > > > I am running MS Office 2007 on an XP machine. The only windows open are > > Outlook, two web browsers and one excel spreadsheet. > > > > Thoughts?
|
Pages: 1 Prev: Select specific location in spreadsheet Next: selecting a cell |