Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cannot find macro
I was alerted when I was opening an excel sheet that there were macros. The
file was originally created by another person. However, when I went in and tried to delete them, I did not see any macro listed. Where can I find these macros? |
#2
|
|||
|
|||
New users wrote:
I was alerted when I was opening an excel sheet that there were macros. The file was originally created by another person. However, when I went in and tried to delete them, I did not see any macro listed. Where can I find these macros? See the messages with subject, macro warning. They solved this problem for me just yesterday. gls858 |
#3
|
|||
|
|||
hi,
if you don't see any macro in the toolsmacromocro box chances are that there are no macros but the modules that used to house the macros are still there and that is what is causing the message. open the vb editor (alt+f11) on the left click the + by your project name(file name) to expand the tree. if you see any modules, double click it. if it is empty click fileremove module. it will ask if you want to save the contents, click no. repeat for all modules. -----Original Message----- I was alerted when I was opening an excel sheet that there were macros. The file was originally created by another person. However, when I went in and tried to delete them, I did not see any macro listed. Where can I find these macros? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping Macro to Find and Mark | New Users to Excel | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
Can't find macro | Excel Worksheet Functions |