Quaisne, You also have to remove the modules on which the macros were stored
have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Quaisne" wrote in
message ...
Okay this is my first post so be gentle.
Could someone tell me how I can get rid of the macro warning box from a
single worksheet.
Someone sent me a spreadsheet to comment on but it contained macros.
The macros were used for navigation purposes so I deleted them.
Unfortunately I cannot get rid of the warning box thjt pops up every
time I open the workbook asking if I want to enable macros or not even
though the worksheet no longer contains macros.
I do not want to change the macro security level as I want to be warned
about macros on other worksheets. I just want to get rid of the warning
on this one workbook.
Can someone tell me how? 
--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile:
http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=475613