gls858

Try here

http://www.nickhodge.co.uk/tipstrick...warningremoval

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"gls858" wrote in message
...
Ken Wright wrote:
One possibility is that you need to delete any empty modules that may
have
housed macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane
you need to search for
your workbook's name, and when you find it you may need to click on the +
to
expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the
brackets
above as opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a
question
re exporting, just
hit no. Then hit File / Close and return to Microsoft Excel and save the
file.


Ken,
thanks for the reply. I did in fact have an empty module. I deleted it and
saved the file. I still get the warning. Any other ideas?

gls858