Thread: strange problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_371_] Rick Rothstein \(MVP - VB\)[_371_] is offline
external usenet poster
 
Posts: 1
Default strange problem

I've not seen that before, but it is easily duplicated with an event macro;
for example...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Resize(1, 2).Select
End Sub

Did you check the code window in the VBA editor for the worksheet affect by
this (perhaps someone is playing a practical joke on you)?

Rick


"-Bryan" wrote in message
...
Suddenly, a sheet I've been working on will select two cells, the one I
select and the one to the right of it, whenever I click on it. This
problem
had popped up once before, and I just closed and reopened the sheet. Now,
I've gone so far as to restart the computer, and it won't clear. It only
happens on the one particular workbook, all others are fine.

Has anyone else had this problem, or know of a solution. I'm on a Sony
Vaio,
running Vista Home and Office 2007 Standard Excel.

Thanks in advance.