Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then
delete the code and save the workbook. Him emailing you the file shouldn't make any
difference - The macro or module would have to be in the file that was being opened at the
time to generate the warning message

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"BillS" wrote in message
.. .
Ken:

I did as you suggested, but "Modules" does not appear under the workbook
name, Just "Excel Objects". Any other suggestions? Would this change if he
e-mailed me the files, rather than me looking at them on his system?

BillS
"Ken Wright" wrote in message
...
You need to delete any empty modules that housed those 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.


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------------------------
--
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------------------------
--



"BillS" wrote in message
. ..
I have a user who has several Excel workbooks that give the macro
warning
when opened, even though there are no macros in the workbooks. His
security
is set to high, and I can arrange to lower the setting if it is
required,
but would prefer to leave it set at the companies default setting
(high).
Does anyone have any idea why a workbook with no macros would trigger
the
warning

Thanxz




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003