Removing VB Code!!!

[Guest]

All,

At work because the email exchange blocks spreadsheets with VB macro's in them I need to remove the below code I have in one spreadsheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub

I dont know what this does but when I remove it and close VB if I go back into it there it is again!

Any ideas?

 

[Peo Sjoblom]

Select the sheet that has the code,right it's sheet tab and select view
code, select
it and delete it, save the workbook

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom

All,

At work because the email exchange blocks spreadsheets with VB macro's in

them I need to remove the below code I have in one spreadsheet:

 

[Guest]

That is what I have been doing!
--
Adam
-----------
Windows 98 + Office Pro 97

Select the sheet that has the code,right it's sheet tab and select view
code, select
it and delete it, save the workbook

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom

All,

At work because the email exchange blocks spreadsheets with VB macro's in

them I need to remove the below code I have in one spreadsheet:

 

[Bernie Deitrick]

Adam,

Don't go back there again: when you open a worksheet's codemodule, Excel
wants to be helpful and puts in those lines, expecting that you want to use
the SelectionChange event.

Simply remove the code, close the code window, then save the workbook.

HTH,
Bernie
MS Excel MVP

All,

At work because the email exchange blocks spreadsheets with VB macro's in

them I need to remove the below code I have in one spreadsheet: