Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is this macro?
In every excel file opening, I also found this dialogue. What is it? How can I delete this?
It increases the file size to twice or triple Code:
http://i433.photobucket.com/albums/qq56/sharephotoonline/4Rum/12-23-20095-25-10PM.png |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is this macro?
Those are not macros. They are what is known as Named Ranges. Search
Excel's Help to learn more about those things. But in this case, the worksheets or rows/columns with those particular Named ranges have been deleted at some time. You could go through that entire list and for any entries that show a #REF error, you could select it and use the [Delete] option to remove its definition from the workbook. I suspect that somewhere in the distant past you had a workbook that had those ranges defined, and other workbooks were based on it, and over time, the worksheets or cells they referred to were deleted, leaving the name definition behind, but with nothing to actually refer to. "finditsol" wrote: In every excel file opening, I also found this dialogue. What is it? How can I delete this? It increases the file size to twice or triple Code: -------------------- http://i433.photobucket.com/albums/q...95-25-10PM.png -------------------- -- finditsol . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |