Private Sub Worksheet_Change(ByVal Target As Range)

[PanzerAttack]

I've a sheet names Customer where I'm using this function

Private Sub Worksheet_Change(ByVal Target As Range)

So that when I change a cell a macro runs.

I've copied this sheet and renamed it business so I don't have to start from scratch but now it keeps jumping to the customer sheet when I make the change in the Business tab.

Does anyone know why?

 

[Steeviee]

You probably have the code in the wrong worksheet???

Press Alt F11. The code needs to be in the new worksheet code (double click on 'Business' in the Project Explorer window - and remove it from wherever it is now!

 

[Smitty]

You'll need to post the code.

Most likely you have an explicit reference to the Customer sheet.

 

[PanzerAttack]

Weirdly I've managed to fix it, I simply saved it to it's own sheet and then copied it back and it was okay.

Thanks for looking though