enable disable macro message

L

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
 
T

Township of East Hanover

Excel 2000.

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

Then look for any code in your Workboook

Rui
 
B

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)
 
L

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.
 
F

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
 
Top