How to turn off macros warning for single workbook?

C

cassa

I have a workbook that doesn't have any macros in it (that I can see)
but I still get the 'macros warning' when I open it. How can I tur
this warning off? (Or delete whatever it is in the spreadsheet that i
activating the warning.)

(I don't know VB, so please be gentle with me!!)

Leann
 
A

Alan

Press Alt and F11 together,
This opens the VB editor,
On the left hand side of the screen you will probably see one or more folder
icons saying Module 1 etc,
Double click these, right click what you see and click 'Remove'
You'll get a save or not message, say 'No'
Double click Sheet1, Sheet2, ThisWorkbook etc, delete anything you find,
Press Alt and F11 together again to exit the VB editor,
Save the file
Regards,
Alan.
 
S

Steve Yandl

There probably once was a macro and the module that contained it is still
present (but empty).

Use Alt plus F11 to get the VB editor. Look in the project window in the
upper left and look under "VBA Project('Name of workbook')". Under it, you
will see a modules folder that contains one or more modules. Right click
the module(s) and choose to remove. Close the VB editor, save changes and
you should be set.

Steve
 
Top