unexisted macro

[Fenton]

Hello experts...

This has been driving me crasy!!

I have this excel file which runs fine for the past few years on excel 97.
It had no problem at all until I upgraded my office to 2003. Now, every
time I open this file, there is a warning saying that this file contains
macro and bla bla bla..... Of course I can set the security level to low to
get away from this.. however, the thing is that I have never created a
macro for this file.. and in fact, when I go into tools->macro->macro, there
is no macro here. So what is this "hidden" macro that the warning message
is warning about? does anyone have any idea? any way to get rid of it?

Thanks
Fenton

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Fenton]

Wow... it works!!!! thanks
This is what I found on every sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
End Sub

I deleted them and the marco warning message is gone! By the way, what does
that code do? What was it there is the first place?

Fenton

 

[Frank Kabel]

Hi
this code does nothing. Just the (empty) stub of an event procedure

 

[Dave Peterson]

But this is where you'd put some code that would fire whenever you changed the
selection on that worksheet.

Try this against a test worksheet in a test workbook. (rightclick on the
worksheet tab and select view code. Then paste this into the code window:


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
msgbox target.address
End Sub


You'll see a message box each time you select a different range.