Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro warning...but no macros! | Excel Programming | |||
macro warning - but no macros | Excel Discussion (Misc queries) | |||
Still Macro Warning w/o Macros ... | Excel Programming | |||
Macro Warning in File w/o Macros? | Excel Programming | |||
Macro warning when no macros | Excel Programming |