enable disable macro message

[Lisa Fischer]

When I open one particular workbook and not others, I get
prompted to either enable or disable macros. I started to
make a macro in this workbook but changed my mind so I
know I caused this problem. Because this is going to drive
me nuts (because I'm just a little anal), I went into the
macros list to delete it, but there is nothing there. If
open VB under View, Code, I get a window that has the
first and last line of a macro under "Worksheet" but I
have no idea how to delete it.

Thanks in advance.
Lisa

 

[Township of East Hanover]

Excel 2000.

On the Menu click: Tools... Macro....Visual Basic Editor

Then look for any code in your Workboook

Rui

 

[Bob Phillips]

Just cut it as you would with text in a Word document.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Lisa Fischer]

Thanks. I already tried that but it reappears on its
own. Very frustrating. I've also tried deleting it and
saving it again.

 

[Frank Kabel]

Hi
what lines appear?
Normally deleting this lines and saving the workbook should do. If this
does not work you may email me your file and I'll have a look at it