Macro warning but no macros
 

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?

Macro warning but no macros
 

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?

Macro warning but no macros
 

go into the VBE (alt+F11), then go into each sheet module (use the project
explorer window). For each sheet module, Click in the sheet module and do
Ctrl+A, then delete. Then click in the little x in the upper left corner
to close the module.

Do this for the thisworkbook module as well.

Delete any regular or standard modules you have, including any blank ones.
Right click, choose delete

Save the workbook. Close and open it.

--
Regards,
Tom Ogilvy


"Peter Chandler" wrote in message
...
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?

Macro warning but no macros
 

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?