Removing VB Code!!!

A

Adam

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?
 
P

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


Adam said:
All,

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

Adam

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


Peo Sjoblom said:
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


Adam said:
All,

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

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

Adam said:
All,

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