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

Excel 2000.

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

Then look for any code in your Workboook

Rui

"Lisa Fischer" wrote in message
...
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

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" wrote in message
...
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

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

-----Original Message-----
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" wrote in message
...
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


.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Lisa Fischer" schrieb im Newsbeitrag
...
Thanks. I already tried that but it reappears on its
own. Very frustrating. I've also tried deleting it and
saving it again.

-----Original Message-----
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" wrote in message
...
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


.