Macro warning box

[Quaisne]

Okay this is my first post so be gentle.

Could someone tell me how I can get rid of the macro warning box from
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 ever
time I open the workbook asking if I want to enable macros or not eve
though the worksheet no longer contains macros.

I do not want to change the macro security level as I want to be warne
about macros on other worksheets. I just want to get rid of the warnin
on this one workbook.

Can someone tell me how? :confused

 

[Paul B]

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

 

[Bob Phillips]

That means there is some macro detritus left over. See
http://www.contextures.com/xlfaqMac.html#NoMacros for full instructions.

 

[Quaisne]

That is suberb that pesky box has now been delt with. It is funny how
things can be so frustrating to deal with when you don't know how.

 

[Quaisne]

Thanks that has worked fine