Worksheet event

[akbar]

Guys,
I'm facing problems with VB scripts.whenever i open an spread sheet,it is asking for enable/disable macros.i've not assigned any macros for any spread sheets.when i go VB design mode this is wht i've seen.
Worksheet
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub


can somebody tell me,what is it doing and from where it came from.because i'm not familiar with macros and VB Scripts.i need to delete this script from my spread sheet for ever.


Regards,
Akbar

[Leith Ross]

Hello akbar,

I can't answer where it came from, but deleting it is easy.

1. Right click on the sheet tab that has the code.
2. Select all the code that appears in the Visual Basic Editor window, and press the Delete key.
3. Press CTRL+S to save the changes.
4. Press ALT+Q to close the VBS and return to Excel.

Sincerely,
Leith Ross

[akbar]

Lieth,
Still the same problem,i'll attach the sheet,can u please have a look on that

Regards,
Akbar

[mudraker]

The attached workbook still has the following code

Please Login or Register  to view this content.

You need to remove the code

Leiths reply gives instructions on how to remove the code

which is basically you select all the code & then delete it

[akbar]

that is what i'm talking about.i deleted the code,then done everything as per leith instructions still the code remains.


Regards,
Akbar

[mudraker]

I have removed the code from the attachment with this reply

Try it & see what happens.

There is nothing in the workbook that stops it from being deleted or would cause the code to re-appear once deleted & the workbook saved

[akbar]

Thanks dear,
that was my mistake,i understood now wht happ.

Regards,
Akbar