| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro warning - how to delete macro
When I open a workbook I receive the macro security warning dialog
box. I would like to delete any macros in this file but cannot find them. I have looked in the VBA code editor, there are no named ranges, when I go to Tools\Macros\Macros there are none listed in the workbook, there are no hidden sheets, there are no external links. Where is that pesky macro? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro warning - how to delete macro
Right click sheet tabs and View Code and check 'This workbook' in VBE
-- If this post helps click Yes --------------- Jacob Skaria "GavinS" wrote: When I open a workbook I receive the macro security warning dialog box. I would like to delete any macros in this file but cannot find them. I have looked in the VBA code editor, there are no named ranges, when I go to Tools\Macros\Macros there are none listed in the workbook, there are no hidden sheets, there are no external links. Where is that pesky macro? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro warning - how to delete macro
Also check Add-In Manager...
http://office.microsoft.com/en-us/ex...037321033.aspx -- If this post helps click Yes --------------- Jacob Skaria "GavinS" wrote: When I open a workbook I receive the macro security warning dialog box. I would like to delete any macros in this file but cannot find them. I have looked in the VBA code editor, there are no named ranges, when I go to Tools\Macros\Macros there are none listed in the workbook, there are no hidden sheets, there are no external links. Where is that pesky macro? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro warning - how to delete macro
Debra Dalgleish shares how to remove the remnants of macros:
http://contextures.com/xlfaqMac.html#NoMacros GavinS wrote: When I open a workbook I receive the macro security warning dialog box. I would like to delete any macros in this file but cannot find them. I have looked in the VBA code editor, there are no named ranges, when I go to Tools\Macros\Macros there are none listed in the workbook, there are no hidden sheets, there are no external links. Where is that pesky macro? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Security Warning | Excel Discussion (Misc queries) | |||
| Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
| Macro Warning | New Users to Excel | |||
| Macro warning box | Excel Discussion (Misc queries) | |||
| macro warning | New Users to Excel | |||
Linear Mode
