enable disable macro 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

enable disable macro message
 

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

enable disable macro 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

enable disable macro message
 

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


.

enable disable macro message
 

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


.