Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
I created a spreadsheet that at one time had some macros in it. Then, I
deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
Remove the module and save
-- Don Guillett SalesAid Software "jd17" wrote in message ... I created a spreadsheet that at one time had some macros in it. Then, I deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
I had already removed the module previously. I'm guessing that there is
still some code somewhere referencing a macro module (even though it has been deleted). Would there be anything else that would cause Excel to think a macro exists? "Don Guillett" wrote: Remove the module and save -- Don Guillett SalesAid Software "jd17" wrote in message ... I created a spreadsheet that at one time had some macros in it. Then, I deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
jd
Code can be in the ThisWorkbook module or in a Worksheet module. You will have to open these individually and EditClear any code snippets you may find. Gord Dibben Excel MVP On Mon, 6 Dec 2004 17:11:03 -0800, "jd17" wrote: I had already removed the module previously. I'm guessing that there is still some code somewhere referencing a macro module (even though it has been deleted). Would there be anything else that would cause Excel to think a macro exists? "Don Guillett" wrote: Remove the module and save -- Don Guillett SalesAid Software "jd17" wrote in message ... I created a spreadsheet that at one time had some macros in it. Then, I deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
I am being frustrated by the same problem. I have a workbook containing 140
sheets that gives me the macro warning message when it is opened. The file does not contain any VB modules. However, in the VB editor, the Window menu does list two sheets plus ThisWorkbook as containing code, but opening any of them in the editor does not show any code. In the left dropdown box, I see listings for Worksheet and Workbook objects (respectively), and clicking on these will create either a Worksheet_SelectionChange or a Workbook_Open procedure. I've created and deleted these a number of times and resaved the file, but I still can't shake Excel thinking it has macros. "Gord Dibben" wrote: jd Code can be in the ThisWorkbook module or in a Worksheet module. You will have to open these individually and EditClear any code snippets you may find. Gord Dibben Excel MVP On Mon, 6 Dec 2004 17:11:03 -0800, "jd17" wrote: I had already removed the module previously. I'm guessing that there is still some code somewhere referencing a macro module (even though it has been deleted). Would there be anything else that would cause Excel to think a macro exists? "Don Guillett" wrote: Remove the module and save -- Don Guillett SalesAid Software "jd17" wrote in message ... I created a spreadsheet that at one time had some macros in it. Then, I deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
rad
Debra Dalgleish has several other things to try. http://www.contextures.on.ca/xlfaqMac.html#NoMacros Gord On Tue, 7 Dec 2004 08:13:10 -0800, "rad2" wrote: I am being frustrated by the same problem. I have a workbook containing 140 sheets that gives me the macro warning message when it is opened. The file does not contain any VB modules. However, in the VB editor, the Window menu does list two sheets plus ThisWorkbook as containing code, but opening any of them in the editor does not show any code. In the left dropdown box, I see listings for Worksheet and Workbook objects (respectively), and clicking on these will create either a Worksheet_SelectionChange or a Workbook_Open procedure. I've created and deleted these a number of times and resaved the file, but I still can't shake Excel thinking it has macros. "Gord Dibben" wrote: jd Code can be in the ThisWorkbook module or in a Worksheet module. You will have to open these individually and EditClear any code snippets you may find. Gord Dibben Excel MVP On Mon, 6 Dec 2004 17:11:03 -0800, "jd17" wrote: I had already removed the module previously. I'm guessing that there is still some code somewhere referencing a macro module (even though it has been deleted). Would there be anything else that would cause Excel to think a macro exists? "Don Guillett" wrote: Remove the module and save -- Don Guillett SalesAid Software "jd17" wrote in message ... I created a spreadsheet that at one time had some macros in it. Then, I deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find Macro code
I followed the link to Chris Pearson's site from this one, and used his
procedure for deleting all VBA code in a project, and it seems to have worked. Curiously, I did have to reset the AutoFilter buttons I have set in some column header cells. At least the macro warning message has stopped. Thanks. "Gord Dibben" wrote: rad Debra Dalgleish has several other things to try. http://www.contextures.on.ca/xlfaqMac.html#NoMacros Gord On Tue, 7 Dec 2004 08:13:10 -0800, "rad2" wrote: I am being frustrated by the same problem. I have a workbook containing 140 sheets that gives me the macro warning message when it is opened. The file does not contain any VB modules. However, in the VB editor, the Window menu does list two sheets plus ThisWorkbook as containing code, but opening any of them in the editor does not show any code. In the left dropdown box, I see listings for Worksheet and Workbook objects (respectively), and clicking on these will create either a Worksheet_SelectionChange or a Workbook_Open procedure. I've created and deleted these a number of times and resaved the file, but I still can't shake Excel thinking it has macros. "Gord Dibben" wrote: jd Code can be in the ThisWorkbook module or in a Worksheet module. You will have to open these individually and EditClear any code snippets you may find. Gord Dibben Excel MVP On Mon, 6 Dec 2004 17:11:03 -0800, "jd17" wrote: I had already removed the module previously. I'm guessing that there is still some code somewhere referencing a macro module (even though it has been deleted). Would there be anything else that would cause Excel to think a macro exists? "Don Guillett" wrote: Remove the module and save -- Don Guillett SalesAid Software "jd17" wrote in message ... I created a spreadsheet that at one time had some macros in it. Then, I deleted/removed the macro modules via Visual Basic Editor. However, I still get a warning (that the spreadsheet has macros) when I open the spreadsheet. I ran the remove hidden name macroprogram. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula, Macro, or VBA code to find and insert | Excel Worksheet Functions | |||
Code to find code | Excel Discussion (Misc queries) | |||
Find last row code | Excel Discussion (Misc queries) | |||
I need to find a macro to find data cut and paste to another colu. | Excel Programming | |||
Help with this Find code please | Excel Programming |