| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Still Thinks Workbook Has Macro Code
I removed the one function I tested in my workbook, but Excel still
prompts with the VBA security box when I open the file. How do I get rid of this? TIA, Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Still Thinks Workbook Has Macro Code
Right click on each mod and choose Remove. Then look at the code for
each worksheet and in ThisWorkbook and make sure there is no code in any of those. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Still Thinks Workbook Has Macro Code
by "mod" I mean Module. Also remove any object modules. (All of this
via the Project Explorer in the VBA window ) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Still Thinks Workbook Has Macro Code
Remove any empty modules
-- Gary's Student "Dan" wrote: I removed the one function I tested in my workbook, but Excel still prompts with the VBA security box when I open the file. How do I get rid of this? TIA, Dan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Still Thinks Workbook Has Macro Code
Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros Dan wrote: I removed the one function I tested in my workbook, but Excel still prompts with the VBA security box when I open the file. How do I get rid of this? TIA, Dan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workbook thinks it is open when it is not | Excel Discussion (Misc queries) | |||
| cell is not empty but excel thinks it is,,,why? | Excel Discussion (Misc queries) | |||
| Excel thinks a file is ReadOnly but it is not. How to fix? | Excel Discussion (Misc queries) | |||
| How do i get VB to reckognise an empty cell when excel thinks it's | Excel Programming | |||
| How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
![Dan[_36_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
