Excel 2010 1

[Khosher]

Hi Guys,

I have just recently upgraded to 2010 from 2007. I have a large enough spreadsheet where I keep alot of my data. Since upgrading to 2010, everytime I click on a cell it launches the MS VB for applications window.

How can I disable this as it is getting a little frustrating.

Thanks for your help.

 

[SkipVought]

Hi,

It launches VB? Nothing else? No Debug Window? No message?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Khosher]

Sorry I porbably should have given you more info but I know nothing of VB. Each time I click a cell it lauches a VB window. When I go to close it asked if I want to close the debugger.

This only happes on 1 out 8 worksheets though. It's driving me nuts.

Thanks.

 

[SkipVought]

On that one worksheet you have a worksheet event.

When you get the message, hit [DEBUG]. This code window will display the code that is causing the debug to occur.

Copy ALL the code in this window and PASTE back here.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Khosher]

Hi Skip,

This is what I get, does this make sense to you ?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
c90
End Sub

Thanks.

 

[SkipVought]

Paste this over that code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'c90
End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Khosher]

You tha man Skip. That worked perfectly. Thanks