Thanks Ken

There was one sheet with a blank Sub. Deleted this and the annoyance has
gone.

Cheers
Peter

"Ken Puls" wrote:

Go into the Visual Basic Editor and check each worksheet in the project.
If there is anything in any module more than "Option Explicit", then
this is why your macro warnings are being triggered. If you really
don't need the code (you created it by accident when playing with a
button), then delete the code.

In addition, you need to make sure there are no standard or class
modules in the project if you want to avoid macro security warnings.

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

Peter Chandler wrote:
I have a spreadsheet that has no macros, names or modules. It previously
opened without giving the macro warning message. After playing around with
some of the tools on the Forms toolbar, I now get the macro warning. I've
deleted all the tools (check boxes and radio buttons) and deleted the range
where I placed these tools, but still can't remove the macro warning. Any
suggestions?